Question 1

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 
A) Level 1 API 
B) Extended SQL Grammar 
C) Core API 
D) Level 2 API

Question 2

SOAP has become ________.

Accepted Answer

A) just a name,not an acronym 
B) a standard protocol for sending any type of message 
C) an old technology replaced by XML 
D) Both A and B are correct 
A) just a name,not an acronym 
B) a standard protocol for sending any type of message 
C) an old technology replaced by XML 
D) Both A and B are correct

Question 3

Only open source products may be used in conjunction with JDBC.

Accepted Answer

A) True 
 B)False

Question 4

OLE DB objects are COM objects.

Accepted Answer

A) True 
 B)False

Question 5

In general,for Web applications it is best to create what type of data source on the Web server?

Accepted Answer

A) File 
B) User 
C) Shared 
D) System 
A) File 
B) User 
C) Shared 
D) System

Question 6

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 
A) Relational data provider 
B) Method provider 
C) Sequential data provider 
D) Tabular data provider

Question 7

Which of the following is not true about bytecode interpretation?

Accepted Answer

A) It may be performed on the client or the server. 
B) Only one bytecode interpreter is needed for all machine architectures. 
C) It is slower than running a program compiled into machine code. 
D) It increases portability. 
A) It may be performed on the client or the server. 
B) Only one bytecode interpreter is needed for all machine architectures. 
C) It is slower than running a program compiled into machine code. 
D) It increases portability.

Question 8

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

Accepted Answer

ADO.NET is an improved and expanded vers

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Java Server Pages (JSP)can run only on Linux or Unix servers.

Accepted Answer

A) True 
 B)False

Question 11

The coding for Java Server Pages must be written in ________.

Accepted Answer

A) Java 
B) JavaScript 
C) C++ 
D) Both A and B are correct 
A) Java 
B) JavaScript 
C) C++ 
D) Both A and B are correct

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The first step in using a JDBC driver is to establish a connection.

Accepted Answer

A) True 
 B)False

Question 14

HTML is defined by the World Wide Web Consortium (W3C).

Accepted Answer

A) True 
 B)False

Question 15

In general,the best type of ODBC data source to define for a Web application is a system data source.

Accepted Answer

A) True 
 B)False

Question 16

The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.

Accepted Answer

A) True 
 B)False

Question 17

What type of JDBC driver is known as a JDBC-ODBC bridge?

Accepted Answer

A) Type 1 driver 
B) Type 2 driver 
C) Type 3 driver 
D) Type 4 driver 
A) Type 1 driver 
B) Type 2 driver 
C) Type 3 driver 
D) Type 4 driver

Question 18

If the Web server and the DBMS are running on the same server,the system has a three-tier architecture.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 13: The Web Server Environment

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

SOAP has become ________.

Only open source products may be used in conjunction with JDBC.

OLE DB objects are COM objects.

In general,for Web applications it is best to create what type of data source on the Web server?

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

Which of the following is not true about bytecode interpretation?

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

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

Java Server Pages (JSP)can run only on Linux or Unix servers.

The coding for Java Server Pages must be written in ________.

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

The first step in using a JDBC driver is to establish a connection.

HTML is defined by the World Wide Web Consortium (W3C).

In general,the best type of ODBC data source to define for a Web application is a system data source.

The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.

What type of JDBC driver is known as a JDBC-ODBC bridge?

If the Web server and the DBMS are running on the same server,the system has a three-tier architecture.

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

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

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