Chapter 11 Questions

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.

B. Only one bytecode interpreter is needed for all machine architectures.

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

B. Type 2 driver

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

B. interface

The first step in using a JDBC driver is to ________. A) establish a connection to the database B) load the driver C) create a statement D) call the DriverManager object

B. load the driver

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#.

C. ADO is harder to understand than OLE DB.

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

C. Converts data source error codes into ODBC standard error codes

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

C. Core SQL Grammar

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

C. DataSets

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

C. HTTP

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.

C. ODBC can be used to access data from spreadsheets.

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

C. Read a Microsoft Word document

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.

C. The application makes a call to the driver.

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

C. The driver

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

C. Type 3 driver

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

C. bytecode interpreter

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

C. driver

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

C. methods

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

C. servlet

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

D. Both B and C are correct

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

D. Level 2 API

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.

D. Microsoft does not supply a data provider for Oracle database.

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.

D. Operations performed on DataSets are also performed on the data on disk.

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

D. System

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

D. Tabular data provider

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

D. Type 4 driver

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

D. properties

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

D. system

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

False

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

False

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

False

An ADO.NET DataSet is connected to databases.

False

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

False

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

False

Database processing and document processing are unrelated to one another.

False

Every DBMS product uses the same API.

False

If the Web server and the DBMS are running on the same server, the system has a three-tier architecture.

False

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

False

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

False

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

False

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

False

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

False

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

False

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

False

ODBC has not had practical success, but has shown great potential for future development.

False

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

False

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

False

The most widely used Web server for all operating systems is Internet Information Services (IIS).

False

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

False

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

False

With ODBC, a file data source is available only to the user that created it.

False

With ODBC, only a single driver is needed to handle all data source types, such as Oracle, DB2, and Access.

False

XML provides a standardized, non-customizable way to describe the content of a document.

False

A multiple-tier ODBC driver may reformat an SQL request, but it does not actually process the SQL statement.

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

Every DBMS product has an application programming interface (API).

True

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

True

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

True

If a server is using a Microsoft Windows operating system, it is usually running Internet Information Server (IIS) as its Web server.

True

In ODBC, the amount of work that the driver must do is largely determined by the degree of SQL-compliance of the data source.

True

In general, the best type of ODBC data source to define for a Web application is a system data source.

True

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

True

Java programs are compiled into machine-independent bytecode.

True

ODBC stands for Open Database Connectivity.

True

ODBC works with table-like data sources such as relational databases and spreadsheets.

True

OLE DB can act as a wrapper for (covers) database native libraries so that the functionality can be provided by OLE.

True

OLE DB can be used to access ODBC data sources.

True

OLE DB is an object-oriented interface.

True

OLE DB objects are COM objects.

True

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

True

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

True

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

True

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

True

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

True

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

True

SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.

True

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.

True

To use JDBC, programs must be written in Java.

True

With ODBC, a database and the DBMS that processes it are identified by the data source.

True

With ODBC, the driver manager serves as an intermediary between the application and the DBMS drivers.

True

XML documents can be automatically generated from database data.

True

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

A. COM

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

A. IRowSet

The coding for Java Server Pages must be written in ________. A) Java B) JavaScript C) C++ D) Both A and B are correct

A. Java

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.

A. Programs must be written in Java.

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.

A. Scripting languages can access OLE DB.

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

A. Type 1 driver

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

A. class library

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

A. driver manager

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

A. file

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

A. iterator

In a three-tier or n-tier architecture, which type of JDBC driver can be used if the DBMS and the Web server are running on the same computer? A) Only Type 1 and Type 2 B) All four Types C) Only Type 3 and Type 4 D) Only Type 2 and Type 3

B. All four Types

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

B. Multiple-tier

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

B. ODBC