Question 1

Which of the following is not true about OLE DB?

Accepted Answer

A) Scripting languages cannot 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. 
E) OLE DB is used as a wrapper for ADO objects. 
A) Scripting languages cannot 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. 
E) OLE DB is used as a wrapper for ADO objects.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The ________ processes ODBC requests and submits specific SQL statements to a given type of data source.

Accepted Answer

A) driver manager 
B) ADO 
C) driver 
D) source converter 
E) ODBC translator 
A) driver manager 
B) ADO 
C) driver 
D) source converter 
E) ODBC translator

Question 6

Briefly describe the components of the ODBC architecture.

Accepted Answer

In the ODBC architecture,the application

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is a type of OLE DB data provider?

Accepted Answer

A) relational data provider 
B) method provider 
C) sequential data provider 
D) tabular data provider 
E) implementation provider 
A) relational data provider 
B) method provider 
C) sequential data provider 
D) tabular data provider 
E) implementation provider

Question 9

Explain the process by which JSP pages are compiled.

Accepted Answer

All JSP pages are compiled into servlets

Question 10

Support for subqueries and creating indexes is a sign of what type of SQL conformance in a DBMS driver?

Accepted Answer

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

Question 11

In PHP,any programming language statements that are to be processed on the server must be enclosed in:

Accepted Answer

A) . B) [php and php]. C) (php and php). D) . E) and . A) . B) [php and php]. C) (php and php). D) . E) and .

Question 12

ODBC stands for Open Database Connectivity.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

What type of JDBC driver translates JDBC calls into DBMS-independent 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 15

Distinguish among the four types of JDBC drivers.

Accepted Answer

Type 1 drivers are JDBC-ODBC bridge driv

Question 16

The first PHP element to be created is the:

Accepted Answer

A) Command object. 
B) Connection object. 
C) Errors collection. 
D) Parameters collection. 
E) RecordSet object. 
A) Command object. 
B) Connection object. 
C) Errors collection. 
D) Parameters collection. 
E) RecordSet object.

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

As compared to CGI files,JSP pages ________.

Accepted Answer

A) are less memory efficient 
B) require more processor time 
C) execute faster 
D) keep more copies of a given page in memory 
E) None of the above. 
A) are less memory efficient 
B) require more processor time 
C) execute faster 
D) keep more copies of a given page in memory 
E) None of the above.

Question 19

The most commonly used Web server on servers running the Unix or Linux operating system is Internet Information Server (IIS).

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is a task performed by the driver according to the ODBC standard?

Accepted Answer

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) Verifies the application to the data source 
E) Converts the data source into an SQL-compliant data structure 
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) Verifies the application to the data source 
E) Converts the data source into an SQL-compliant data structure

Exam 13: The Web Server Environment

Which of the following is not true about OLE DB?

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

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

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

The ________ processes ODBC requests and submits specific SQL statements to a given type of data source.

Briefly describe the components of the ODBC architecture.

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

Which of the following is a type of OLE DB data provider?

Explain the process by which JSP pages are compiled.

Support for subqueries and creating indexes is a sign of what type of SQL conformance in a DBMS driver?

In PHP,any programming language statements that are to be processed on the server must be enclosed in:

ODBC stands for Open Database Connectivity.

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

What type of JDBC driver translates JDBC calls into DBMS-independent network protocols?

Distinguish among the four types of JDBC drivers.

The first PHP element to be created is the:

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

As compared to CGI files,JSP pages ________.

The most commonly used Web server on servers running the Unix or Linux operating system is Internet Information Server (IIS).

Which of the following is a task performed by the driver according to the ODBC standard?

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