Database Processing, 15e (Kroenke)
Chapter 11: The Web Server Environment
1) Every DBMS product has an application programming interface (API).
2) Every DBMS product uses the same API.
3) ODBC stands for Open Database Connectivity.
4) If a server is using a Microsoft Windows operating system, it is usually running Internet
Information Server (IIS) as its Web server.
5) The most widely used Web server for all operating systems is Internet Information Services
(IIS).
6) If the Web server and DBMS are running on the same server, the system has a three-tier
architecture.
7) ODBC has not had practical success, but has shown great potential for future development.
8) ODBC works with table-like data sources such as relational databases and spreadsheets.
9) OLE DB can act as a wrapper for (covers) database native libraries so that the functionality
can be provided by OLE.
10) With ODBC, a database and the DBMS that processes it are identified by the data source.
11) With ODBC, the driver manager serves as an intermediary between the application and the
DBMS drivers.
12) With ODBC, only a single driver is needed to handle all data source types (i.e., Oracle, DB2,
and Access).
13) In ODBC, the amount of work that the driver must do is largely determined by the degree of
SQL-compliance of the data source.
14) A multiple-tier ODBC driver may reformat an SQL request, but it does not actually process
the SQL statement.
15) With ODBC, a file data source is available only to the user that created it.
16) In general, the best type of ODBC data source to define for a Web application, is a system
data source.
17) OLE DB objects are COM objects.
18) OLE DB can be used to access ODBC data sources.
19) OLE DB is an object-oriented interface.
20) In OLE DB, a RecordSet is a more abstract representation of a rowset.
21) Object classes have properties that represent characteristics of the objects in the class.
22) One of the properties of all collections is Count, which is the number of objects in the
collection.
23) In OLE DB, all of an object’s properties must be exposed in all interfaces, but not all
methods have to be exposed.
24) One important result of OLE DB is that data does not have to be moved or converted from
one form to another.
25) An OLE DB service provider accepts data from an OLE DB tabular data provider.
26) ADO provides access to OLE functionality to programming languages that ordinarily could
not access OLE functions.
28) ADO is frequently used for database applications.
29) ADO.NET is a completely new product, with no connection to ADO except the similar
name.
30) ADO.NET provides the capability to create and process in-memory databases called
DataSets.
31) An ADO.NET DataSet has all the characteristics, features, and functions of a regular
database.
32). The ADO.NET object classes are grouped into Data Providers and DataSequences
33) An ADO.NET dataset can have primary and foreign keys, but ADO.NET does not support
referential integrity.
34) Once an ADO.NET dataset is constructed, its contents can be formatted as an XML
document with a single command.
35) An ADO.NET dataset can only be used with optimistic locking.
36) Only open source products may be used in conjunction with JDBC.
37) To use JDBC, programs must be written in Java.
38) The only difference between a JDBC driver type 2 & 3 is that one connects to a DBMS-
independent network, while the other connects to a DBMS-dependent network.
40) Type 2 JDBC drivers access ODBC data sources over a network.
41) Type 4 JDBC drivers translate JDBC calls into a DBMS-independent network protocol.
42) Java programs are compiled into machine-independent bytecode.
43) Java programs tend to execute faster than programs compiled into machine-dependent code
because the Java virtual machine only has to interpret the bytecode.
44) An applet is a Java bytecode program that executes on the Web server.
45) Applet bytecode is sent to the user’s computer and is invoked using the HTTP protocol.
46) Java programs that access a database from an applet must use a Type 2 JDBC driver.
47) The first step in using a JDBC driver is to establish a connection.
48) Java Server Pages (JSP) can run only on Linux or Unix servers.
49) JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the
compiled version of the page.
50) Basic Web pages are created using Hypertext Markup Language (HTML).
51) HTML is defined by the World Wide Web Consortium (W3C).
52) A common default Web page name recognized by most Web servers is FirstPage.html.
53) Database processing and document processing are unrelated to one another.
54) HTML is an application of a document markup language called Standard Generalized
Markup Language (SGML).
55) In the 1990s the database community and the document processing community created a
standard called Expandable Markup Language (XML).
56) XML provides a standardized, non-customizable way to describe the content of a document.
57) XML documents can be automatically generated from database data.
58) SOAP was originally an XML-based standard for providing remote procedure calls over the
Internet.
59) Oracle requires the use of Java for generating XML documents from database data.
60) MySQL does not have facilities for generating XML documents from database data.
61) PHP code is executed on a server and can generate HTML code that is sent to the client
computer.
62) 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.
63) Which of the following can only interact with relational database and table-like data
structures?
A) OLE DB
B) ODBC
C) ASP
D) ADO
64) 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.
65) 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
66) 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
67) 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
68) 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
69) 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
70) 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
71) 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
72) 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.
73) 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
74) 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
75) A ________ data source can be shared among database users if they have the same DBMS
driver and privilege to access the database.
A) file
B) common
C) user
D) system
76) 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