Question 1

Java programs are compiled into machine-independent bytecode.

Accepted Answer

A) True 
 B)False

Question 2

Which standard interface in OLE DB is invoked to declare a forward-only cursor?

Accepted Answer

A) IRowSet 
B) IAccessor 
C) IColumnsInfo 
D) adXact 
E) ADODB 
A) IRowSet 
B) IAccessor 
C) IColumnsInfo 
D) adXact 
E) ADODB

Question 3

What are the different types of conformance levels within the ODBC standard,and why do they exist?

Accepted Answer

There are two types of conformance level

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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) shared 
D) system 
E) user 
A) file 
B) common 
C) shared 
D) system 
E) user

Question 7

The characteristics of an object are called ________.

Accepted Answer

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

Question 8

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

Accepted Answer

A) Java 
B) JavaScript 
C) C++ 
D) Visual Basic 
E) All of the above. 
A) Java 
B) JavaScript 
C) C++ 
D) Visual Basic 
E) All of the above.

Question 9

Every DBMS product uses the same API.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is 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) A and B 
E) A,B and C 
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) A and B 
E) A,B and C

Question 12

One important result of OLE DB is that data does not have to be moved or converted from one form to another.

Accepted Answer

A) True 
 B)False

Question 13

PDO stands for:

Accepted Answer

A) PHP Data Objects. 
B) PHP Design Objects. 
C) Personal Data Objects. 
D) Personal Design Objects. 
E) None of the above. 
A) PHP Data Objects. 
B) PHP Design Objects. 
C) Personal Data Objects. 
D) Personal Design Objects. 
E) None of the above.

Question 14

A data source that is fully SQL-compliant would use what type of DBMS driver?

Accepted Answer

A) Single-tier 
B) Multiple-tier 
C) SQL transform 
D) Text-based 
E) Conformance 
A) Single-tier 
B) Multiple-tier 
C) SQL transform 
D) Text-based 
E) Conformance

Question 15

Type 2 JDBC drivers access ODBC data sources over a network.

Accepted Answer

A) True 
 B)False

Question 16

JSP can be coded only in Java and JavaScript.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A(n)________ is a Java program that is interpreted and executed by a bytecode interpreter on the Web server.

Accepted Answer

A) applet 
B) Java virtual machine 
C) servlet 
D) HTTP 
E) JDBC translator 
A) applet 
B) Java virtual machine 
C) servlet 
D) HTTP 
E) JDBC translator

Question 19

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. 
E) B and C 
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. 
E) B and C

Question 20

A set of objects and the properties and methods that they expose are known as a(n)________.

Accepted Answer

A) provider 
B) data consumer 
C) implementation 
D) instantiation 
E) interface 
A) provider 
B) data consumer 
C) implementation 
D) instantiation 
E) interface

Exam 13: The Web Server Environment

Java programs are compiled into machine-independent bytecode.

Which standard interface in OLE DB is invoked to declare a forward-only cursor?

What are the different types of conformance levels within the ODBC standard,and why do they exist?

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

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

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

The characteristics of an object are called ________.

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

Every DBMS product uses the same API.

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

Which of the following is true about ADO.NET?

One important result of OLE DB is that data does not have to be moved or converted from one form to another.

PDO stands for:

A data source that is fully SQL-compliant would use what type of DBMS driver?

Type 2 JDBC drivers access ODBC data sources over a network.

JSP can be coded only in Java and JavaScript.

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

A(n)________ is a Java program that is interpreted and executed by a bytecode interpreter on the Web server.

Which of the following is true of JDBC?

A set of objects and the properties and methods that they expose are known as a(n)________.

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