Question 1

The ODBC standard defines a means of doing which of the following?

Accepted Answer

A) Start transactions 
B) Rollback transactions 
C) Create a connection 
D) Issue SQL commands 
E) All of the above 
A) Start transactions 
B) Rollback transactions 
C) Create a connection 
D) Issue SQL commands 
E) All of the above

Question 2

Possible uses of XML go far beyond using it to display Web pages.

Accepted Answer

A) True 
 B)False

Question 3

JDBC drivers only exist for a limited number of DBMS products at this time.

Accepted Answer

A) True 
 B)False

Question 4

In a three-tier or n-tier architecture,which type of JDBC driver can be used if the DBMS and the Web server are running on the same computer?

Accepted Answer

A) Type 1 driver 
B) Type 2 driver 
C) Type 3 driver 
D) Type 4 driver 
E) All of the above. 
A) Type 1 driver 
B) Type 2 driver 
C) Type 3 driver 
D) Type 4 driver 
E) All of the above.

Question 5

In database/ XML applications,it is a recommended practice that ________.

Accepted Answer

A) elements carry data,and attributes carry metadata 
B) elements carry metadata,and attributes carry data 
C) elements and attributes carry data,and the XML Schema carry metadata 
D) elements and attributes carry metadata,and the XML Schema carry data 
E) either A or B 
A) elements carry data,and attributes carry metadata 
B) elements carry metadata,and attributes carry data 
C) elements and attributes carry data,and the XML Schema carry metadata 
D) elements and attributes carry metadata,and the XML Schema carry data 
E) either A or B

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

When XSLT actions are indicated in a loop,the loop ends with .

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Database processing and document processing are unrelated to one another.

Accepted Answer

A) True 
 B)False

Question 10

ODBC works with table-like data sources such as relational databases and spreadsheets.

Accepted Answer

A) True 
 B)False

Question 11

XML Schema that have all elements residing at the same level are called ________.

Accepted Answer

A) flat 
B) structured 
C) single-leveled 
D) multi-leveled 
E) styled 
A) flat 
B) structured 
C) single-leveled 
D) multi-leveled 
E) styled

Question 12

The XML Schema "mother of all schemas" is located at ________.

Accepted Answer

A) a user-defined Web server for each organization 
B) www.w3.org 
C) www.google.com 
D) www.microsoft.com 
E) www.xmlschema.net 
A) a user-defined Web server for each organization 
B) www.w3.org 
C) www.google.com 
D) www.microsoft.com 
E) www.xmlschema.net

Question 13

How does an application determine the level of ODBC conformance available from a driver?

Accepted Answer

A) The application makes a call to the driver manager. 
B) The application makes a call to the data source. 
C) The application makes a call to the driver. 
D) The developer must determine the level of conformance before the application is written. 
E) It does not have to determine ODBC conformance since all ODBC drivers have the same functionality by definition. 
A) The application makes a call to the driver manager. 
B) The application makes a call to the data source. 
C) The application makes a call to the driver. 
D) The developer must determine the level of conformance before the application is written. 
E) It does not have to determine ODBC conformance since all ODBC drivers have the same functionality by definition.

Question 14

Applet bytecode is sent to the user's computer and is invoked using the HTTP protocol.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

What are flat and structured XML Schemas?

Accepted Answer

XML Schemas are called "flat" when all t

Question 17

How can XML be used with a DBMS?

Accepted Answer

One example is the use of XML with SQL S

Question 18

What is an XML DTD?

Accepted Answer

An XML DTD is a Document Type Declaratio

Question 19

The first section of an XML document might be a ________.

Accepted Answer

A) Document Definition Section (DDS) 
B) Document Type Declaration (DT
D)  
C) Data Type (DTYP
E)  
D) Document Type (DOCTYP
E)  
E) Type Declaration (TYPEDECL) 
A) Document Definition Section (DDS) 
B) Document Type Declaration (DT
D)  
C) Data Type (DTYP
E)  
D) Document Type (DOCTYP
E)  
E) Type Declaration (TYPEDECL)

Question 20

Elements of complexType must have more than one simple element.

Accepted Answer

A) True 
 B)False

Exam 11: The Web Server Environment

The ODBC standard defines a means of doing which of the following?

Possible uses of XML go far beyond using it to display Web pages.

JDBC drivers only exist for a limited number of DBMS products at this time.

In a three-tier or n-tier architecture,which type of JDBC driver can be used if the DBMS and the Web server are running on the same computer?

In database/ XML applications,it is a recommended practice that ________.

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

When XSLT actions are indicated in a loop,the loop ends with .

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

Database processing and document processing are unrelated to one another.

ODBC works with table-like data sources such as relational databases and spreadsheets.

XML Schema that have all elements residing at the same level are called ________.

The XML Schema "mother of all schemas" is located at ________.

How does an application determine the level of ODBC conformance available from a driver?

Applet bytecode is sent to the user's computer and is invoked using the HTTP protocol.

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

What are flat and structured XML Schemas?

How can XML be used with a DBMS?

What is an XML DTD?

The first section of an XML document might be a ________.

Elements of complexType must have more than one simple element.

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