Question 1

Explain the relationships among native DBMS libraries,ODBC,OLE DB,ADO,and ADO.NET and why each led to the development of the next.

Accepted Answer

All of these provide means of data acces

Question 2

XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.

Accepted Answer

A) True 
 B)False

Question 3

The SQL Server statement SELECT...FOR XML can only be used with a single table.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

In XML Schema,the default minimum cardinality can be overridden using the minOccurs attributes.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

XSLT is a non-declarative transformation language.

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 XML Schema,the default cardinality of elements is 0.1.

Accepted Answer

A) True 
 B)False

Question 13

XSLT processors are context oriented;that is,each statement is evaluated within the context of the match that has already been made.

Accepted Answer

A) True 
 B)False

Question 14

What is an XML global element?

Accepted Answer

An XML Schema global element is a group

Question 15

JSP pages are ________.

Accepted Answer

A) automatically compiled by the servlet processor as needed 
B) required to be compiled by the developer before being made public 
C) automatically checked for syntax errors by the servlet as they are written 
D) slower to execute but more memory efficient than CGI files 
E) A and D 
A) automatically compiled by the servlet processor as needed 
B) required to be compiled by the developer before being made public 
C) automatically checked for syntax errors by the servlet as they are written 
D) slower to execute but more memory efficient than CGI files 
E) A and D

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is a type of element in an XML Schema?

Accepted Answer

A) simple 
B) composite 
C) compound 
D) complex 
E) A and D 
A) simple 
B) composite 
C) compound 
D) complex 
E) A and D

Question 20

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.

Exam 11: The Web Server Environment

Explain the relationships among native DBMS libraries,ODBC,OLE DB,ADO,and ADO.NET and why each led to the development of the next.

XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.

The SQL Server statement SELECT...FOR XML can only be used with a single table.

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

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

In XML Schema,the default minimum cardinality can be overridden using the minOccurs attributes.

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

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

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

XSLT is a non-declarative transformation language.

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

In XML Schema,the default cardinality of elements is 0.1.

XSLT processors are context oriented;that is,each statement is evaluated within the context of the match that has already been made.

What is an XML global element?

JSP pages are ________.

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

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

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

Which of the following is a type of element in an XML Schema?

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

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

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 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters