Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which of the following can only interact with relational database and table-like data structures?

Accepted Answer

A) OLE DB 
B) ODBC 
C) ASP 
D) ADO 
E) All of the above. 
A) OLE DB 
B) ODBC 
C) ASP 
D) ADO 
E) All of the above.

Question 3

The ODBC standard defines a means of doing which of the following?

Accepted Answer

A) Start transactions 
B) Rollback transactions 
C) Create a connection 
D) Issue SQL commands 
E) All of the above. 
A) Start transactions 
B) Rollback transactions 
C) Create a connection 
D) Issue SQL commands 
E) All of the above.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

A) file 
B) common 
C) shared 
D) system 
E) user 
A) file 
B) common 
C) shared 
D) system 
E) user

Question 9

Which of the following is true about ODBC?

Accepted Answer

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. 
E) ODBC does not include facilities to return error messages. 
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. 
E) ODBC does not include facilities to return error messages.

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The first step in using a JDBC driver is to ________.

Accepted Answer

A) establish a connection to the database 
B) load the driver 
C) create a statement 
D) call the DriverManager object 
E) invoke the executeQuery method 
A) establish a connection to the database 
B) load the driver 
C) create a statement 
D) call the DriverManager object 
E) invoke the executeQuery method

Question 12

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?

Accepted Answer

A) Type 1 driver 
B) Type 2 driver 
C) Type 3 driver 
D) Type 4 driver 
E) All of the above. 
A) Type 1 driver 
B) Type 2 driver 
C) Type 3 driver 
D) Type 4 driver 
E) All of the above.

Question 13

ADO.NET in-memory databases are called ________.

Accepted Answer

A) adoBases 
B) adoDatabases 
C) dotNetBases 
D) dotNetDatabases 
E) DataSets 
A) adoBases 
B) adoDatabases 
C) dotNetBases 
D) dotNetDatabases 
E) DataSets

Question 14

OLE DB objects are COM objects.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is a function performed by the driver manager in ODBC?

Accepted Answer

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) Convert data source error codes into ODBC error codes 
E) B and C 
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) Convert data source error codes into ODBC error codes 
E) B and C

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

What type of JDBC driver translates JDBC calls in DBMS-specific network protocols?

Accepted Answer

A) Type J-O driver 
B) Type 1 driver 
C) Type 2 driver 
D) Type 3 driver 
E) Type 4 driver 
A) Type J-O driver 
B) Type 1 driver 
C) Type 2 driver 
D) Type 3 driver 
E) Type 4 driver

Question 19

Which of the following is true about JSP code?

Accepted Answer

A) It must be written in Java or JavaScript. 
B) It does not have access to HTTP functionality. 
C) It must be coded as complete Java classes and methods. 
D) It is automatically converted into Java servlets. 
E) All of the above. 
A) It must be written in Java or JavaScript. 
B) It does not have access to HTTP functionality. 
C) It must be coded as complete Java classes and methods. 
D) It is automatically converted into Java servlets. 
E) All of the above.

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 13: The Web Server Environment

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

Which of the following can only interact with relational database and table-like data structures?

The ODBC standard defines a means of doing which of the following?

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

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

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

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

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.

Which of the following is true about ODBC?

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

The first step in using a JDBC driver is to ________.

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?

ADO.NET in-memory databases are called ________.

OLE DB objects are COM objects.

Which of the following is a function performed by the driver manager in ODBC?

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

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

What type of JDBC driver translates JDBC calls in DBMS-specific network protocols?

Which of the following is true about JSP code?

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

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters