Question 1

In ODBC,the amount of work that the driver must do is largely determined by the degree of SQL-compliance of the data source.

Accepted Answer

A) True 
 B)False  True

Question 2

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 levels within the ODBC standard-ODBC conformance and SQL conformance.ODBC conformance deals with the features and functions that are available to the application program through the DBMS driver API.The SQL conformance standard deals with the SQL statements,expressions,and data types that the driver can process.The reason for these levels is to accommodate the varying ability of different vendors to comply with the power and expressiveness of the ODBC standard and the SQL language.Without these different levels of compliance,the ODBC standard would either be too simple to be very useful,or too rigorous for many vendors to comply with.

Question 3

What type of JDBC driver connects to the native API of the DBMS?

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 B

Question 4

An ADO.NET DataSet has all the characteristics,features,and functions of a regular database.

Accepted Answer

A) True 
 B)False

Question 5

ADO.NET in-memory databases are called ________.

Accepted Answer

A) adoBases 
B) adoDatabases 
C) DataSets 
D) dotNetDatabases 
A) adoBases 
B) adoDatabases 
C) DataSets 
D) dotNetDatabases

Question 6

Which of the following is a task performed by the driver according to the ODBC standard?

Accepted Answer

A) Determines the appropriate DBMS 
B) Validates the format of the ODBC command received from the application 
C) Converts data source error codes into ODBC standard error codes 
D) Converts the data source into an SQL-compliant data structure 
A) Determines the appropriate DBMS 
B) Validates the format of the ODBC command received from the application 
C) Converts data source error codes into ODBC standard error codes 
D) Converts the data source into an SQL-compliant data structure

Question 7

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) JDBC translator 
A) applet 
B) Java virtual machine 
C) servlet 
D) JDBC translator

Question 8

What type of JDBC driver translates JDBC calls into DBMS-independent network protocols?

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 9

HTML is an application of ________.

Accepted Answer

A) SGML 
B) XML 
C) SOAP 
D) XSLT 
A) SGML 
B) XML 
C) SOAP 
D) XSLT

Question 10

An ADO.NET dataset can have primary and foreign keys,but ADO.NET does not support referential integrity.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

ODBC stands for Open Database Connectivity.

Accepted Answer

A) True 
 B)False

Question 13

An important method of a collection is a(n)________,which can be used to pass through or otherwise identify the items in the collection.

Accepted Answer

A) iterator 
B) identifier 
C) converter 
D) transformer 
A) iterator 
B) identifier 
C) converter 
D) transformer

Question 14

JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the compiled version of the page.

Accepted Answer

A) True 
 B)False

Question 15

Briefly describe PHP.

Accepted Answer

PHP,which is an abbreviation for PHP: Hy

Question 16

Java programs are compiled into machine-independent bytecode.

Accepted Answer

A) True 
 B)False

Question 17

PHP code is executed on a server and can generate HTML code that is sent to the client computer.

Accepted Answer

A) True 
 B)False

Question 18

Explain the process by which JSP pages are compiled.

Accepted Answer

All JSP pages are compiled into servlets

Question 19

Compare and contrast servlets and applets.

Accepted Answer

Servlets and applets are both Java progr

Question 20

ADO.NET is a completely new product,with no connection to ADO except the similar name.

Accepted Answer

A) True 
 B)False

Exam 13: The Web Server Environment

In ODBC,the amount of work that the driver must do is largely determined by the degree of SQL-compliance of the data source.

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

What type of JDBC driver connects to the native API of the DBMS?

An ADO.NET DataSet has all the characteristics,features,and functions of a regular database.

ADO.NET in-memory databases are called ________.

Which of the following is a task performed by the driver according to the ODBC standard?

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

What type of JDBC driver translates JDBC calls into DBMS-independent network protocols?

HTML is an application of ________.

An ADO.NET dataset can have primary and foreign keys,but ADO.NET does not support referential integrity.

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

ODBC stands for Open Database Connectivity.

An important method of a collection is a(n)________,which can be used to pass through or otherwise identify the items in the collection.

JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the compiled version of the page.

Briefly describe PHP.

Java programs are compiled into machine-independent bytecode.

PHP code is executed on a server and can generate HTML code that is sent to the client computer.

Explain the process by which JSP pages are compiled.

Compare and contrast servlets and applets.

ADO.NET is a completely new product,with no connection to ADO except the similar name.

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