Question 1

An ADO.NET Data Provider is a(n)________ that provides ADO.NET services.

Accepted Answer

A) class library 
B) windows application 
C) Web application 
D) XML service 
A) class library 
B) windows application 
C) Web application 
D) XML service

Question 2

An OLE DB service provider accepts data from an OLE DB tabular data provider.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Briefly describe NetBeans.

Accepted Answer

NetBeans is an open-source Integrated De

Question 5

The SQL Server statement SELECT *
FROM Table01
FOR XML RAW
Tells SQL Server to place the data values from the columns in the table into XML ________.

Accepted Answer

A) elements 
B) attributes 
C) elements or attributes,as chosen by SQL Server 
D) elements or attributes,as designated by the XML Schema 
A) elements 
B) attributes 
C) elements or attributes,as chosen by SQL Server 
D) elements or attributes,as designated by the XML Schema

Question 6

The first PHP element to be created is the ________.

Accepted Answer

A) Command object 
B) Connection object 
C) Errors collection 
D) Parameters collection 
A) Command object 
B) Connection object 
C) Errors collection 
D) Parameters collection

Question 7

Object classes have properties that represent characteristics of the objects in the class.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is not 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) Operations performed on DataSets are also performed on the data on disk. 
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) Operations performed on DataSets are also performed on the data on disk.

Question 9

Which of the following is not true about OLE DB?

Accepted Answer

A) Scripting languages can 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. 
A) Scripting languages can 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.

Question 10

What is XML,and why is it significantly better than HTML?

Accepted Answer

XML stands for Extensible Markup Languag

Question 11

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) Only Type 1 and Type 2 
B) All four Types 
C) Only Type 3 and Type 4 
D) Only Type 2 and Type 3 
A) Only Type 1 and Type 2 
B) All four Types 
C) Only Type 3 and Type 4 
D) Only Type 2 and Type 3

Question 12

OLE DB can be used to access ODBC data sources.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is true of JDBC?

Accepted Answer

A) Programs must be written in Java. 
B) JDBC only works with open-source products. 
C) JDBC is only available for Unix-like operating systems,such as Linux. 
D) JDBC is actually a DBMS. 
A) Programs must be written in Java. 
B) JDBC only works with open-source products. 
C) JDBC is only available for Unix-like operating systems,such as Linux. 
D) JDBC is actually a DBMS.

Question 15

OLE DB is an object-oriented interface.

Accepted Answer

A) True 
 B)False

Question 16

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 
A) are less memory efficient 
B) require more processor time 
C) execute faster 
D) keep more copies of a given page in memory

Question 17

XML provides a standardized,non-customizable way to describe the content of a document.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not true of ADO?

Accepted Answer

A) ADO is a simple object model for OLE DB data consumers. 
B) ADO can be used from VBScript and JavaScript. 
C) ADO is harder to understand than OLE DB. 
D) ADO can be called from languages such as Visual Basic.NET,Java and C#. 
A) ADO is a simple object model for OLE DB data consumers. 
B) ADO can be used from VBScript and JavaScript. 
C) ADO is harder to understand than OLE DB. 
D) ADO can be called from languages such as Visual Basic.NET,Java and C#.

Question 20

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 
A) OLE DB 
B) ODBC 
C) ASP 
D) ADO

Exam 13: The Web Server Environment

An ADO.NET Data Provider is a(n)________ that provides ADO.NET services.

An OLE DB service provider accepts data from an OLE DB tabular data provider.

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

Briefly describe NetBeans.

The SQL Server statement SELECT * FROM Table01 FOR XML RAW Tells SQL Server to place the data values from the columns in the table into XML ________.

The first PHP element to be created is the ________.

Object classes have properties that represent characteristics of the objects in the class.

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

Which of the following is not true about OLE DB?

What is XML,and why is it significantly better than HTML?

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?

OLE DB can be used to access ODBC data sources.

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

Which of the following is true of JDBC?

OLE DB is an object-oriented interface.

As compared to CGI files,JSP pages ________.

XML provides a standardized,non-customizable way to describe the content of a document.

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

Which of the following is not true of ADO?

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

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