Question 1

The final step of using a PHP connection to a DBMS is to:

Accepted Answer

A) open the connection. 
B) test the connection. 
C) query the database. 
D) process the query results. 
E) close the connection. 
A) open the connection. 
B) test the connection. 
C) query the database. 
D) process the query results. 
E) close the connection.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

What is ADO.NET and what is an ADO.NET DataSet?

Accepted Answer

ADO.NET is an improved and expanded vers

Question 4

Which of the following is true about ADO.NET DataSets?

Accepted Answer

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) A and B 
E) A,B and C 
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) A and B 
E) A,B and C

Question 5

Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver?

Accepted Answer

A) Level 1 API 
B) Extended SQL Grammar 
C) Core API 
D) Level 2 API 
E) Core SQL Grammar 
A) Level 1 API 
B) Extended SQL Grammar 
C) Core API 
D) Level 2 API 
E) Core SQL Grammar

Question 6

OLE DB is an object-oriented interface.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Briefly describe Eclipse.

Accepted Answer

Eclipse is an open-source Integrated Dev

Question 10

ODBC acts as a wrapper for OLE DB.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Why is the decomposition of the features and functions of a DBMS into different objects an advantage for OLE DB?

Accepted Answer

First,by breaking the features of the DB

Question 13

To use JDBC,programs must be written in Java.

Accepted Answer

A) True 
 B)False

Question 14

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.

Accepted Answer

A) driver manager 
B) OLE DB interface 
C) ODBC driver 
D) data source 
E) database connector 
A) driver manager 
B) OLE DB interface 
C) ODBC driver 
D) data source 
E) database connector

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

OLE DB can be used to access ODBC data sources.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not true about Tomcat?

Accepted Answer

A) It is a servlet processor. 
B) It can be used as a standalone Web server. 
C) It is often used in conjunction with Apache. 
D) It is an applet processor. 
E) It has limited Web server facilities. 
A) It is a servlet processor. 
B) It can be used as a standalone Web server. 
C) It is often used in conjunction with Apache. 
D) It is an applet processor. 
E) It has limited Web server facilities.

Question 18

How does an application determine the level of ODBC conformance available from a driver?

Accepted Answer

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. 
E) It does not have to determine ODBC conformance since all ODBC drivers have the same functionality by definition. 
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. 
E) It does not have to determine ODBC conformance since all ODBC drivers have the same functionality by definition.

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 13: The Web Server Environment

The final step of using a PHP connection to a DBMS is to:

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

What is ADO.NET and what is an ADO.NET DataSet?

Which of the following is true about ADO.NET DataSets?

Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver?

OLE DB is an object-oriented interface.

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

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

Briefly describe Eclipse.

ODBC acts as a wrapper for OLE DB.

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

Why is the decomposition of the features and functions of a DBMS into different objects an advantage for OLE DB?

To use JDBC,programs must be written in Java.

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.

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

OLE DB can be used to access ODBC data sources.

Which of the following is not true about Tomcat?

How does an application determine the level of ODBC conformance available from a driver?

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

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

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