Question 1

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 2

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

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 3

Briefly describe PHP.

Accepted Answer

PHP,which is an abbreviation for PHP: Hy

Question 4

The SQL Server statement SELECT...FOR XML is used to place column data as elements in an XML document.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

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 8

Distinguish among the four types of JDBC drivers.

Accepted Answer

Type 1 drivers are JDBC-ODBC bridge driv

Question 9

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 
E) signal 
A) iterator 
B) identifier 
C) converter 
D) transformer 
E) signal

Question 10

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

Accepted Answer

XML stands for Extensible Markup Languag

Question 11

An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.

Accepted Answer

A) True 
 B)False

Question 12

Support for subqueries and creating indexes is a sign of what type of SQL conformance in a DBMS driver?

Accepted Answer

A) Level 2 API 
B) Minimum SQL Grammar 
C) Core API 
D) Extended SQL Grammar 
E) Core SQL Grammar 
A) Level 2 API 
B) Minimum SQL Grammar 
C) Core API 
D) Extended SQL Grammar 
E) Core SQL Grammar

Question 13

Every DBMS product uses the same API.

Accepted Answer

A) True 
 B)False

Question 14

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 15

For database/XML applications,a good rule to follow is that elements are used to carry data and attributes are used to carry metadata.

Accepted Answer

A) True 
 B)False

Question 16

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 
E) All of the above 
A) OLE DB 
B) ODBC 
C) ASP 
D) ADO 
E) All of the above

Question 17

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 18

In the 1990s the database community and the document processing community created a standard called Expandable Markup Language (XML).

Accepted Answer

A) True 
 B)False

Question 19

MySQL Server does not have facilities for generating XML documents from database data.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 11: The Web Server Environment

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

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

Briefly describe PHP.

The SQL Server statement SELECT...FOR XML is used to place column data as elements in an XML document.

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

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

Which of the following is not true of ADO?

Distinguish among the four types of JDBC drivers.

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

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

An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.

Support for subqueries and creating indexes is a sign of what type of SQL conformance in a DBMS driver?

Every DBMS product uses the same API.

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

For database/XML applications,a good rule to follow is that elements are used to carry data and attributes are used to carry metadata.

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

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

In the 1990s the database community and the document processing community created a standard called Expandable Markup Language (XML).

MySQL Server does not have facilities for generating XML documents from database data.

As compared to CGI files,JSP pages ________.

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

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

Big Data datawarehouse and Business Intelligence Systems

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 Eclipse PDT

Business Intelligence Systems

Filters