Question 1

MySQL does not have facilities for generating XML documents from database data.

Accepted Answer

A) True 
 B)False

Question 2

PDO stands for ________.

Accepted Answer

A) PHP Data Objects 
B) PHP Design Objects 
C) Personal Data Objects 
D) Personal Design Objects 
A) PHP Data Objects 
B) PHP Design Objects 
C) Personal Data Objects 
D) Personal Design Objects

Question 3

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 4

ODBC has not had practical success,but has shown great potential for future development.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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) Both B and C are correct 
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

Question 7

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 8

The final step of using a PHP connection to a DBMS is to ________.

Accepted Answer

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

Question 9

One of the properties of all collections is Count,which is the number of objects in the collection.

Accepted Answer

A) True 
 B)False

Question 10

The actions that an object can perform are called ________.

Accepted Answer

A) procedures 
B) collections 
C) methods 
D) properties 
A) procedures 
B) collections 
C) methods 
D) properties

Question 11

OLE DB breaks the features and functions of a DBMS into what type of objects?

Accepted Answer

A) COM 
B) JSP 
C) MTS 
D) ODBC 
A) COM 
B) JSP 
C) MTS 
D) ODBC

Question 12

Applet bytecode is transmitted to the user's computer via ________.

Accepted Answer

A) the JDBC driver 
B) the Java virtual machine 
C) HTTP 
D) the bytecode interpreter 
A) the JDBC driver 
B) the Java virtual machine 
C) HTTP 
D) the bytecode interpreter

Question 13

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

Accepted Answer

A) It is an improved and expanded version of ADO. 
B) It facilitates the transformation of XML documents to and from relational database constructs. 
C) It provides the ability to create and process in-memory databases. 
D) Microsoft does not supply a data provider for Oracle database. 
A) It is an improved and expanded version of ADO. 
B) It facilitates the transformation of XML documents to and from relational database constructs. 
C) It provides the ability to create and process in-memory databases. 
D) Microsoft does not supply a data provider for Oracle database.

Question 14

The most widely used Web server for all operating systems is Internet Information Services (IIS).

Accepted Answer

A) True 
 B)False

Question 15

Database processing and document processing are unrelated to one another.

Accepted Answer

A) True 
 B)False

Question 16

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 17

A ________ data source can be shared among database users as long as they have the same DBMS driver and privilege to access the database.

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

With ODBC,the driver manager serves as an intermediary between the application and the DBMS drivers.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 13: The Web Server Environment

MySQL does not have facilities for generating XML documents from database data.

PDO stands for ________.

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

ODBC has not had practical success,but has shown great potential for future development.

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

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

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

The final step of using a PHP connection to a DBMS is to ________.

One of the properties of all collections is Count,which is the number of objects in the collection.

The actions that an object can perform are called ________.

OLE DB breaks the features and functions of a DBMS into what type of objects?

Applet bytecode is transmitted to the user's computer via ________.

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

The most widely used Web server for all operating systems is Internet Information Services (IIS).

Database processing and document processing are unrelated to one another.

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

A ________ data source can be shared among database users as long as they have the same DBMS driver and privilege to access the database.

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

With ODBC,the driver manager serves as an intermediary between the application and the DBMS drivers.

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

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters