Q&A Hero

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.

Q: Cloud services allow any organization to quickly and economically add information technology services such as applications, storage, servers, processing power, databases, and infrastructure to its IT portfolio.

Q: Many companies are already working on the development of a new breed of services based on XML and Web technologies.

Q: To be able to use a DTD file to define elements within an XML document, the DTD must be stored within that XML document.

Q: The first line of an XML document represents the document declaration, and it is mandatory.

Q: HTML is designed to facilitate the exchange of structured documents, such as orders and invoices, over the Internet.

Q: ColdFusion is a Web application server.

Q: A Web browser's function is to display a page on the client computer. The browser, through its use of HTML, does not have computational abilities beyond formatting output text and accepting form field inputs.

Q: The only time the client and server computers communicate is when the client requests a page -when the user clicks a link- and the server sends the requested page to the client.

Q: The label "stateless system" indicates that, at any given time, a Web server knows the status of the clients communicating with it.

Q: The browser's interpretation and presentation capabilities are sufficient to develop Web-based applications.

Q: APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.

Q: An API uses script files that perform specific functions on the client's parameters that are passed to the Web server.

Q: The CGI is a newer Web-server interface standard that is much more efficient and faster than a dynamic link library (DLL).

Q: Extending the Web server functionality implies that the Web server and the Web-to-database middleware will properly communicate with each other.

Q: A client-side extension is a program that interacts directly with the Web server to handle specific types of requests.

Q: A database server-side extension is known as Web-to-database middleware.

Q: When an end user uses a Web browser to dynamically query a database, the client browser actually requests a Web page.

Q: The Web has helped create a new information dissemination standard.

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

Q: The effects of bad database design, implementation, and management are multiplied in an environment in which transactions may be measured in hundreds of thousands per day, rather than in hundreds per day.

Q: Whether you purchase online or by standing in line, the system-level transaction details are essentially the same and they require the same basic database structures and relationships.

Q: The creation and management of user interfaces and database connectivity are not affected by the Web's existence.

Q: Most database professionals do not consider the DBMS connection to the Internet to be a critical element in IS development.

Q: Many organizations rely on their IT departments to create universal data access architectures based on Internet standards.

Q: Java applications are compiled and stored in the Web browser.

Q: A good API makes it easy to develop a program by providing all of the building blocks.

Q: An API (application programming interface) is defined as a set of routines, protocols, and tools for building software applications.

Q: Usually, the native database connectivity interface provided by the vendor is not the only way to connect to a database; most current DBMS products support other database connectivity standards, the most common being ODBC.

Q: Database connectivity software is also known as database middleware because it interfaces between the application program and the database.

Q: The DO-UNDO-REDO protocol defines three types of operations. What are they?

Q: What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?

Q: Describe performance transparency and heterogeneity transparency.

Q: Explain the difference between homogeneous and heterogeneous distributed database systems.

Q: A fully distributed database management system must perform all of the functions of a centralized DBMS. What are these functions?

Q: The ____________________ commit protocolguarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.

Q: The database description, known as the distributed ____________________ schema, is the common database schema used by local TPs to translate user requests into subqueries (remote requests) that will be processed by different DPs.

Q: The ____________________ fragment condition indicates that each row is unique, regardless of the fragment in which it is located.

Q: If a DDBMS exhibits ____________________ transparency, the user does not need to know that the data are partitionedmeaning the table's rows and columns are split vertically or horizontally and stored among multiple sites.