Q&A Hero

Q: A(n) ________ is a Java program that is interpreted and executed by a bytecode interpreter on the Web server. A) applet B) Java virtual machine C) servlet D) JDBC translator

Q: Applet bytecode is transmitted to the user's computer via ________. A) the JDBC driver B) the Java virtual machine C) HTTP D) the bytecode interpreter

Q: Which of the following is not true about bytecode interpretation? A) It may be performed on the client or the server. B) Only one bytecode interpreter is needed for all machine architectures. C) It is slower than running a program compiled into machine code. D) It increases portability.

Q: A Java virtual machine is actually a ________. A) program compiler B) JDBC data source C) bytecode interpreter D) JDBC driver

Q: What type of JDBC driver translates JDBC calls into DBMS-specific network protocols? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver

Q: What type of JDBC driver connects to the native API of the DBMS? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver

Q: What type of JDBC driver translates JDBC calls into DBMS-independent network protocols? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver

Q: What type of JDBC driver is known as a JDBC-ODBC bridge? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver

Q: Which of the following is true of JDBC? A) Programs must be written in Java. B) JDBC only works with open-source products. C) JDBC is only available for Unix-like operating systems, such as Linux. D) JDBC is actually a DBMS.

Q: Which of the following is not true about ADO.NET DataSets? A) They can have multiple tables and relationships. B) They can have foreign keys and surrogate keys. C) They can support referential integrity actions. D) Operations performed on DataSets are also performed on the data on disk.

Q: An ADO.NET Data Provider is a(n) ________ that provides ADO.NET services. A) class library B) windows application C) Web application D) XML service

Q: ADO.NET in-memory databases are called ________. A) adoBases B) adoDatabases C) DataSets D) dotNetDatabases

Q: Which of the following is not true about ADO.NET? A) It is an improved and expanded version of ADO. B) It facilitates the transformation of XML documents to and from relational database constructs. C) It provides the ability to create and process in-memory databases. D) Microsoft does not supply a data provider for Oracle database.

Q: Which of the following is not true of ADO? A) ADO is a simple object model for OLE DB data consumers. B) ADO can be used from VBScript and JavaScript. C) ADO is harder to understand than OLE DB. D) ADO can be called from languages such as Visual Basic.NET, Java and C#.

Q: Which standard interface in OLE DB is invoked to declare a forward-only cursor? A) IRowSet B) IAccessor C) IColumnsInfo D) adXact

Q: Which of the following is a type of OLE DB data provider? A) Relational data provider B) Method provider C) Sequential data provider D) Tabular data provider

Q: A set of objects and the properties and methods that they expose are known as a(n) ________. A) provider B) interface C) implementation D) instantiation

Q: An important method of a collection is a(n) ________, which can be used to pass through or otherwise identify the items in the collection. A) iterator B) identifier C) converter D) transformer

Q: The actions that an object can perform are called ________. A) procedures B) collections C) methods D) properties

Q: The characteristics of an object are called ________. A) classes B) collections C) methods D) properties

Q: Which of the following is not true about OLE DB? A) Scripting languages can access OLE DB. B) OLE DB is object-oriented. C) OLE DB can access ODBC data sources. D) OLE DB can access non-relational data sources.

Q: OLE DB breaks the features and functions of a DBMS into what type of objects? A) COM B) JSP C) MTS D) ODBC

Q: In general, for Web applications it is best to create what type of data source on the Web server? A) File B) User C) Shared D) System

Q: A data source that is local to a single computer and can be used by the operating system and any user on that computer is called a ________ data source. A) file B) user C) shared D) system

Q: A ________ data source can be shared among database users as long as they have the same DBMS driver and privilege to access the database. A) file B) common C) user D) system

Q: Support for subqueries and creating indexes is a sign of what type of SQL grammar conformance in a DBMS driver? A) Level 2 API Grammar B) Minimum SQL Grammar C) Core SQL Grammar D) Extended SQL Grammar

Q: Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver? A) Level 1 API B) Extended SQL Grammar C) Core API D) Level 2 API

Q: How does an application determine the level of ODBC conformance available from a driver? A) The application makes a call to the driver manager. B) The application makes a call to the data source. C) The application makes a call to the driver. D) The developer must determine the level of conformance before the application is written.

Q: A data source that is fully SQL-compliant would use what type of DBMS driver? A) Single-tier B) Multiple-tier C) SQL transform D) Text-based

Q: The ________ processes ODBC requests and submits specific SQL statements to a given type of data source. A) driver manager B) ADO C) driver D) source converter

Q: Which of the following is a task performed by the driver according to the ODBC standard? A) Determines the appropriate DBMS B) Validates the format of the ODBC command received from the application C) Converts data source error codes into ODBC standard error codes D) Converts the data source into an SQL-compliant data structure

Q: The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________. A) driver manager B) DBMS C) ODBC driver D) data source

Q: Which of the following is a function performed by the driver manager in ODBC? A) Submit SQL statements to the data source B) Determine the type of DBMS that processes a given ODBC data source C) Load the appropriate ODBC driver into memory D) Both B and C are correct

Q: Which does the ODBC standard not define a means of doing? A) Start transactions B) Rollback transactions C) Read a Microsoft Word document D) Issue SQL commands

Q: According to the ODBC standard, which of the following is not part of the specification of a data source? A) The associated DBMS B) The database C) The driver D) The operating system

Q: Which of the following is true about ODBC? A) ODBC has experienced little practical success. B) ODBC requires developers to have a thorough knowledge of many DBMS native libraries. C) ODBC can be used to access data from spreadsheets. D) ODBC has an object-oriented interface.

Q: Which of the following can only interact with relational database and table-like data structures? A) OLE DB B) ODBC C) ASP D) ADO

Q: The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.

Q: PHP code is executed on a server and can generate HTML code that is sent to the client computer.

Q: MySQL does not have facilities for generating XML documents from database data.

Q: Oracle requires the use of Java for generating XML documents from database data.

Q: XML documents can be automatically generated from database data.

Q: In the 1990s the database community and the document processing community created a standard called Expandable Markup Language (XML).

Q: HTML is an application of a document markup language called Standard Generalized Markup Language (SGML).

Q: Database processing and document processing are unrelated to one another.

Q: A common default Web page name recognized by most Web servers is FirstPage.html.

Q: HTML is defined by the World Wide Web Consortium (W3C).

Q: Basic Web pages are created using Hypertext Markup Language (HTML).

Q: JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the compiled version of the page.

Q: Java Server Pages (JSP) can run only on Linux or Unix servers.

Q: The first step in using a JDBC driver is to establish a connection.

Q: Java programs that access a database from an applet must use a Type 2 JDBC driver.

Q: Applet bytecode is sent to the user's computer and is invoked using the HTTP protocol.

Q: An applet is a Java bytecode program that executes on the Web server.

Q: Java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode.

Q: Java programs are compiled into machine-independent bytecode.

Q: Type 4 JDBC drivers translate JDBC calls into a DBMS-independent network protocol.

Q: Type 2 JDBC drivers access ODBC data sources over a network.

Q: JDBC-ODBC bridge drivers resolve inconsistencies between Java and C/C++ to allow Java access to ODBC data sources.

Q: JDBC drivers only exist for a limited number of DBMS products at this time.

Q: To use JDBC, programs must be written in Java.

Q: Only open source products may be used in conjunction with JDBC.

Q: An ADO.NET dataset can only be used with optimistic locking.

Q: Once an ADO.NET dataset is constructed, its contents can be formatted as an XML document with a single command.

Q: An ADO.NET dataset can have primary and foreign keys, but ADO.NET does not support referential integrity.

Q: An ADO.NET DataSet is connected to databases.

Q: An ADO.NET DataSet has all the characteristics, features, and functions of a regular database.

Q: ADO.NET provides the capability to create and process in-memory databases called DataSets.

Q: ADO.NET is a completely new product, with no connection to ADO except the similar name.

Q: ADO was (and still is) frequently used for database applications.

Q: ADO is accessible from languages such as C++ and C#, but not Visual Basic or scripting languages.

Q: ADO provides access to OLE functionality to programming languages that ordinarily could not access OLE functions.

Q: An OLE DB service provider accepts data from an OLE DB tabular data provider.

Q: One important result of OLE DB is that data does not have to be moved or converted from one form to another.

Q: In OLE DB, all of an object's properties must be exposed in all interfaces, but not all methods have to be exposed.

Q: One of the properties of all collections is Count, which is the number of objects in the collection.

Q: Object classes have properties that represent characteristics of the objects in the class.

Q: In OLE DB, a RecordSet is a more abstract representation of a rowset.

Q: OLE DB is an object-oriented interface.

Q: OLE DB can be used to access ODBC data sources.