Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

Compare and contrast servlets and applets.

Accepted Answer

Servlets and applets are both Java programs compiled into machine-independent bytecode.Both are interpreted and executed by bytecode interpreters called Java virtual machines.Both are invoked using the HTTP protocol.Servlets,however,are interpreted and executed on the Web server computer.It then sends its results to the user's computer via the response capabilities of HTTP.Applets,on the other hand,are interpreted and executed on the user's computer.The bytecode for the applet is transmitted via HTTP to the user's computer,where the Java virtual machine will interpret and execute it locally.

Question 3

With ODBC,a database and the DBMS that processes it are identified by the data source.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

An applet is a Java bytecode program that executes on the Web server.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

With ODBC,a file data source is available only to the user that created it.

Accepted Answer

A) True 
 B)False

Question 11

According to the ODBC standard,which of the following is not part of the specification of a data source?

Accepted Answer

A) The associated DBMS 
B) The database 
C) The driver 
D) The operating system 
E) The network platform 
A) The associated DBMS 
B) The database 
C) The driver 
D) The operating system 
E) The network platform

Question 12

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#. 
E) All of the above are true of ADO. 
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#. 
E) All of the above are true of ADO.

Question 13

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 14

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

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 15

Briefly describe PHP.

Accepted Answer

PHP,which is an abbreviation for PHP: Hy

Question 16

An ADO.NET DataSet is connected to databases.

Accepted Answer

A) True 
 B)False

Question 17

A common default Web page name recognized by most Web servers is FirstPage.html.

Accepted Answer

A) True 
 B)False

Question 18

A Java virtual machine is actually a ________.

Accepted Answer

A) program compiler 
B) JDBC data source 
C) bytecode interpreter 
D) JDBC driver 
E) servlet 
A) program compiler 
B) JDBC data source 
C) bytecode interpreter 
D) JDBC driver 
E) servlet

Question 19

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 20

The actions that an object can perform are called ________.

Accepted Answer

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

Exam 13: The Web Server Environment

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

Compare and contrast servlets and applets.

With ODBC,a database and the DBMS that processes it are identified by the data source.

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

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

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

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

An applet is a Java bytecode program that executes on the Web server.

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

With ODBC,a file data source is available only to the user that created it.

According to the ODBC standard,which of the following is not part of the specification of a data source?

Which of the following is not true of ADO?

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

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

Briefly describe PHP.

An ADO.NET DataSet is connected to databases.

A common default Web page name recognized by most Web servers is FirstPage.html.

A Java virtual machine is actually a ________.

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

The actions that an object can perform are called ________.

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