Question 1

The first step in using a JDBC driver is to ________.

Accepted Answer

A) establish a connection to the database 
B) load the driver 
C) create a statement 
D) call the DriverManager object 
A) establish a connection to the database 
B) load the driver 
C) create a statement 
D) call the DriverManager object

Question 2

Basic Web pages are created using Hypertext Markup Language (HTML).

Accepted Answer

A) True 
 B)False

Question 3

Give an example of how XML can be used with a DBMS.

Accepted Answer

One example is the use of XML with SQL S

Question 4

Which of the following is not true about XML?

Accepted Answer

A) It is a subset of SGML. 
B) Additional standards and capabilities have been added to XML processing. 
C) It is a hybrid of document processing and database processing. 
D) It is a subset of HTML. 
A) It is a subset of SGML. 
B) Additional standards and capabilities have been added to XML processing. 
C) It is a hybrid of document processing and database processing. 
D) It is a subset of HTML.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not true about Tomcat?

Accepted Answer

A) It is a servlet processor. 
B) It can be used as a standalone Web server. 
C) It is often used in conjunction with Apache. 
D) It is an applet processor. 
A) It is a servlet processor. 
B) It can be used as a standalone Web server. 
C) It is often used in conjunction with Apache. 
D) It is an applet processor.

Question 7

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 8

XML stands for ________.

Accepted Answer

A) Experimental Markup Language 
B) Extendable Markup Language 
C) Extensible Markup Language 
D) Active X-control Markup Language 
A) Experimental Markup Language 
B) Extendable Markup Language 
C) Extensible Markup Language 
D) Active X-control Markup Language

Question 9

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

Accepted Answer

A) provider 
B) interface 
C) implementation 
D) instantiation 
A) provider 
B) interface 
C) implementation 
D) instantiation

Question 10

The ________ processes ODBC requests and submits specific SQL statements to a given type of data source.

Accepted Answer

A) driver manager 
B) ADO 
C) driver 
D) source converter 
A) driver manager 
B) ADO 
C) driver 
D) source converter

Question 11

SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.

Accepted Answer

A) True 
 B)False

Question 12

The characteristics of an object are called ________.

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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. 
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.

Question 15

Briefly describe the components of the ODBC architecture.

Accepted Answer

In the ODBC architecture,the application

Question 16

OLE DB can act as a wrapper for (covers)database native libraries so that the functionality can be provided by OLE.

Accepted Answer

A) True 
 B)False

Question 17

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.

Accepted Answer

A) driver manager 
B) DBMS 
C) ODBC driver 
D) data source 
A) driver manager 
B) DBMS 
C) ODBC driver 
D) data source

Question 18

In PHP,any programming language statements that are to be processed on the server must be enclosed in ________.

Accepted Answer

A)  
B) [php and php] 
C) (php and php) 
D)  
A)  
B) [php and php] 
C) (php and php) 
D)

Question 19

ADO is accessible from languages such as C++ and C#,but not Visual Basic or scripting languages.

Accepted Answer

A) True 
 B)False

Question 20

A Java virtual machine is actually a ________.

Accepted Answer

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

Exam 13: The Web Server Environment

The first step in using a JDBC driver is to ________.

Basic Web pages are created using Hypertext Markup Language (HTML).

Give an example of how XML can be used with a DBMS.

Which of the following is not true about XML?

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

Which of the following is not true about Tomcat?

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

XML stands for ________.

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

The ________ processes ODBC requests and submits specific SQL statements to a given type of data source.

SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.

The characteristics of an object are called ________.

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

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

Briefly describe the components of the ODBC architecture.

OLE DB can act as a wrapper for (covers)database native libraries so that the functionality can be provided by OLE.

The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.

In PHP,any programming language statements that are to be processed on the server must be enclosed in ________.

ADO is accessible from languages such as C++ and C#,but not Visual Basic or scripting languages.

A Java virtual machine is actually a ________.

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