Q&A Hero

Q: ____ are general statements of direction or action that communicate and support DBA goals.a. Standards b. Policies c. Documentationd. Procedures

Q: The DBA's ____ role covers activities involving the use of the DBMS.a. administrative b. arbitration c. technicald. managerial

Q: As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.a. control and planning b. conflict and problem-resolution c. policies and standardsd. security and privacy

Q: The DBA's ____ role is focused on personnel management and on interactions with the end-user community.a. administrative b. arbitration c. technicald. managerial

Q: The ____ administrator is responsible for strategic planning.a. system b. data c. databased. program

Q: There is a growing trend toward ____ in the data-management function.a. cross-training b. encapsulation c. specializationd. centralization

Q: It is common practice to define the DBA function by dividing the DBA operations according to the ____ phases.a. SLA b. DBLC c. SDLCd. MRA

Q: The person responsible for the control of the centralized and shared database is the database ____.a. analyst b. administrator c. programmerd. user

Q: When introducing a database into an organization, a(n) ____ impact is likely because the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions.a. cultural b. managerial c. technicald. operational

Q: What are some of the features provided by Web application servers?

Q: What is JavaScript?

Q: What is a server-side extension?

Q: What are the main types of objects in the OLE-DB model?

Q: What are the components in the basic ODBC architecture?

Q: A DBMS that supports ____ exchanges can integrate with external systems such as theWeb, mobile data, and legacy systems, thus enabling the creation of new types of systems.

Q: Using an XML ____________________, a company would be able to validate the data for values that may be out of range, incorrect dates, valid values, and so on.

Q: A(n) ____________________ provides limited additional semantic value to XML, such as data type support or data validation rules.

Q: Extensible Hypertext Markup Language (XHTML) is the next generation of ____________________ based on the XML framework.

Q: XML tags must be well formed; that is, each opening tag has a corresponding ____________________ tag.

Q: XML is derived from the _____________________________________________, an international standard for the publication and distribution of highly complex technical documents.

Q: Because ____________________ e-commerce integrates business processes among companies, it requires the transfer of business information among different business entities.

Q: ____________________ transactionsthe sale of products or servicescan take place between businesses or between a business and a consumer.

Q: ____________________-side data input validation is one of the most basic requirements for Web applications.

Q: A Web ____________________ server is a middleware application that expands the functionality of Web servers by linking them to a wide range of services.

Q: Regardless of the type of Web-server interface used, the Web-to-database ____________________ program must be able to connect with the database.

Q: APIs are faster than _________________________ scripts because the code is resident in memory and there is no need to run an external program for each request.

Q: ____________________ Web pages are at the heart of current generation Web sites.

Q: The Web ____________________ is the main hub through which all Internet services are accessed.

Q: ___________________________________ is an application programming interface that allows a Java program to interact with a wide range of data sources (relational databases, tabular data sources, spreadsheets, and text files).

Q: The Microsoft ____________________ frameworkis a component-based platform for developing distributed, heterogeneous, interoperable applications aimed at manipulating any type of data over any network under any operating system and any programming language.

Q: ______________________________ provides a unified interface to access data from any programming language that uses the underlying OLE-DB objects.

Q: A(n) ____________________is written in a programming language that is not compiled, but is interpreted and executed at run time.

Q: In the OLE-DB model, the ____________________ acts like a data consumer of the data provider and as a data provider for the data consumer (end-user application).

Q: ____________________are objects (applications or processes) that request and use data.

Q: ____________________ are objects that manage the connection with a data source and provide data to the consumers.

Q: A(n) ____________________ is a unique name by which the data source will be known to ODBC, and therefore, to applications.

Q: _________________________ is a higher-level object-oriented application interface used to access remote database servers.

Q: ODBC is ____________________'s implementation of a superset of the SQL Access Group CLI.

Q: ODBC, OLE-DB, and ADO.NET form the backbone of the ______________________________ architecture.

Q: In the ____ category, the cloud service provider offers the capability to build and deploy consumer-created applications using the provider's cloud infrastructure.a. API as a Service (AaaS) b. Infrastructure as a Service (IaaS) c. Software as a Service (SaaS)d. Platform as a Service (PaaS)

Q: The ____ type of cloud infrastructure is built by a third-party organization to sell cloud services to the general public.a. communityb. public c. globald. private

Q: In 2006, ____ began using the term cloud computing to describe a new set of innovative Web-based services.a. Google and Amazon b. Google and Sun c. Microsoft and Sund. XML

Q: DBMS vendors can publish ____ to facilitate data exchanges and the creation of data views from multiple applications for multiple industries.a. metadictionaries b. database support c. Web pagesd. XML databases

Q: Using ____, you can extract data from an XML document and convert it into a text file.a. XMLD b. XSLT c. DTDd. XML schema

Q: The ____is an advanced data definition language that is used to describe the structure (elements, data types, relationship types, ranges, and default values) of XML data documents.a. XHTML b. HTML schema c. DTDd. XML schema

Q: A(n) ____ file provides the composition of the database's logical model and defines the syntax rules for an XML document.a. XMLD b. HTML c. DTDd. meta

Q: Every XML document has a ____.a. root element b. base tag c. schemad. DTD

Q: The XML metalanguage allows the definition of new ____, such as <ProdPrice>, to describe the data elements used in an XML document.a. elements b. tags c. schemasd. DTDs

Q: ____ is a Web application server that provides the ability to connect Web servers to multiple data sources.a. Access b. ColdFusion/JRun c. FoxProd. dBase

Q: Microsoft's alternative to Java is ____.a. Active X b. JavaScript c. VBScriptd. Visual C++

Q: ____ is embedded inside an HTML page and is activated by triggering events such as clicking on a link.a. A plug-in b. A browser c. Visual Basicd. VBScript

Q: What is a feature of a Web application server? a. It is Microsoft's implementation of a superset of the SQL Access Group CLI standard for database access. b. It is automatically invoked by the browser when needed. c. It runs on the client machine, freeing server resources. d. It provides an integrated development environment with session management and support for persistent application variables.

Q: ____is a scripting language that allows Web authors to design interactive sites.a. Visual Basic b. HTML c. JavaScriptd. Java

Q: A ____ is an external application that is automatically invoked by the browser when needed.a. Web client b. plug-in c. Web serviced. Web server

Q: Client-side extensions are available in various forms, such as ____.a. COBOL b. Java and JavaScript c. Visual Basic .NETd. Visor.Net

Q: Which of the following is a client-side extension?a. ActiveX b. ODBC c. SQL*Netd. TCP/IP

Q: The Web browser's job is to ____the HTML code that it receives from the Web server.a. analyze b. interpret c. transformd. save

Q: When using an Oracle database, your Web-to-database middleware can connect to the database via ____.a. ODBX b. CGI c. SQL*Netd. SQL*Plus

Q: Each time the end user clicks a hyperlink, the browser generates a(n) ____ GET page request that is sent to the designated Web server, using the TCP/IP Internet protocol.a. HTML b. browser c. HTTPd. API

Q: What is a disadvantage of using an API Web-server interface? a. It is slower than CGI. b. It is very inefficient because it uses DLLs. c. You need to run an external program for each request. d. An error can bring down the Web server.

Q: A programming language typically used for CGI scripts is ____.a. PERL b. Java c. SQLd. JavaScript

Q: Which of the following is a well-defined Web-server interface?a. Common Gateway Interface b. Disk Operating System c. Windows 98d. AppleTalk

Q: There are currently ____ well-defined Web-server interfaces.a. one b. two c. fived. ten

Q: What is the last step in the exchange between a Web browser and a database? a. The HTML output is displayed on the client computer's Web browser. b. The middleware receives the query result and creates the HTML-formatted page. c. The Web browser requests a page from a Web server. d. The Web-to-database middleware uses ODBC to connect to the database.

Q: What is the first step in the exchange between a Web browser and a database? a. The HTML output is displayed on the client computer's Web browser. b. The middleware receives the query result and creates the HTML-formatted page. c. The client's Web browser requests a page from a Web server. d. The Web-to-database middleware uses ODBC to connect to the database.

Q: Another name for a database server-side extension is ____.a. a Web server b. a Web application server c. Web-to-database middlewared. a database application server

Q: A server-side extension ____. a. provides its services to the Web server in a way that is totally transparent to the client browser b. must be downloaded and installed in the client computer c. is only available for servers running Windows 2000 or greater d. is not required to access a database over the Internet

Q: Of the following, what is one of the benefits of rapid development at manageable costs for Internet technologies? a. Platform independence and portability b. Availability of multiple development tools c. Reduced requirements d. Reduced training time

Q: Of the following, what is one of the benefits of hardware and software independence of Internet technologies? a. Global access b. Reduced costs of maintaining private networks c. Savings in equipment and software acquisition d. Multiple platform development

Q: ____ is an OO programming language developed by Sun Microsystems that runs on top of the Web browser software.a. Visual Basic b. Java c. JavaScriptd. VBScript

Q: The ____ is the most specialized object in the ADO.NET framework.a. Command b. DataReader c. DataAdapterd. DataSet

Q: The ____ object is the in-memory representation of the data in the database.a. Command b. DataReader c. DataAdapterd. DataSet

Q: The ____ object is a specialized object that creates a read-only session with the database to retrieve data sequentially (forward only) in a very fast manner.a. Command b. DataReader c. DataAdapterd. DataSet

Q: Based on Microsoft's Component Object Model (COM), ____ is database middleware that adds object-oriented functionality for access to relational and nonrelational data.a. MS-DB b. OLE-DB c. COM-DBvd. ODBC

Q: The ODBC API standard defines three levels of compliance: ____, Level-1, and Level-2, which provide increasing levels of functionality.a. Complete b. Basic c. Cored. Level-0

Q: In the ODBC architecture, a(n) ____ is in charge of managing all database connections.a. API b. data source name c. ODBC driverd. driver manager

Q: ____ is a higher-level object-oriented application interface used to access remote database servers.a. API b. ODBC c. DAOd. RDO

Q: ODBC works on the ____ operating system.a. mainframe b. UNIX c. Windowsd. Linux

Q: ____ is a collection of technologies used to access any type of data source and manage the data through a common interface. a. DAO c. ODBC b. UDA d. OLE-DB

Q: The initial costs of using cloud services tend to be significantly higher than building on-premise IT infrastructures.