Deck 13: The Web Server Environment

Question 1

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

Answer 1

False

Question 2

With ODBC,only a single driver is needed to handle all data source types,such as Oracle,DB2,and Access.

Answer 2

False

Question 3

ODBC stands for Open Database Connectivity.

Answer 3

True

Question 4

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

Question 5

Every DBMS product uses the same API.

Question 6

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

Question 7

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

Question 8

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

Question 9

ODBC has not had practical success,but has shown great potential for future development.

Question 10

Every DBMS product has an application programming interface (API).

Question 11

The most widely used Web server for all operating systems is Internet Information Services (IIS).

Question 12

OLE DB can be used to access ODBC data sources.

Question 13

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

Question 14

OLE DB objects are COM objects.

Question 15

OLE DB is an object-oriented interface.

Question 16

A multiple-tier ODBC driver may reformat an SQL request,but it does not actually process the SQL statement.

Question 17

If a server is using a Microsoft Windows operating system,it is usually running Internet Information Server (IIS)as its Web server.

Question 18

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

Question 19

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

Question 20

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

Question 21

Type 2 JDBC drivers access ODBC data sources over a network.

Question 22

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

Question 23

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

Question 24

JDBC-ODBC bridge drivers resolve inconsistencies between Java and C/C++ to allow Java access to ODBC data sources.

Question 25

ADO was (and still is)frequently used for database applications.

Question 26

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

Question 27

An ADO.NET dataset can only be used with optimistic locking.

Question 28

Object classes have properties that represent characteristics of the objects in the class.

Question 29

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

Question 30

ADO provides access to OLE functionality to programming languages that ordinarily could not access OLE functions.

Question 31

Only open source products may be used in conjunction with JDBC.

Question 32

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

Question 33

In OLE DB,all of an object's properties must be exposed in all interfaces,but not all methods have to be exposed.

Question 34

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

Question 35

Once an ADO.NET dataset is constructed,its contents can be formatted as an XML document with a single command.

Question 36

An ADO.NET DataSet is connected to databases.

Question 37

An OLE DB service provider accepts data from an OLE DB tabular data provider.

Question 38

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

Question 39

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

Question 40

To use JDBC,programs must be written in Java.

Question 41

Java programs that access a database from an applet must use a Type 2 JDBC driver.

Question 42

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

Question 43

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

Question 44

Oracle requires the use of Java for generating XML documents from database data.

Question 45

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

Question 46

Java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode.

Question 47

HTML is defined by the World Wide Web Consortium (W3C).

Question 48

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

Question 49

Database processing and document processing are unrelated to one another.

Question 50

Type 4 JDBC drivers translate JDBC calls into a DBMS-independent network protocol.

Question 51

XML documents can be automatically generated from database data.

Question 52

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

Question 53

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

Question 54

Java programs are compiled into machine-independent bytecode.

Question 55

XML provides a standardized,non-customizable way to describe the content of a document.

Question 56

HTML is an application of a document markup language called Standard Generalized Markup Language (SGML).

Question 57

Java Server Pages (JSP)can run only on Linux or Unix servers.

Question 58

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

Question 59

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

Question 60

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

Question 61

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

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

Question 62

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

A)OLE DB
B)ODBC
C)ASP
D)ADO

Question 63

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

A)Single-tier
B)Multiple-tier
C)SQL transform
D)Text-based

Question 64

A ________ data source can be shared among database users as long as they have the same DBMS driver and privilege to access the database.

A)file
B)common
C)user
D)system

Question 65

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

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 66

The characteristics of an object are called ________.

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

Question 67

Which does the ODBC standard not define a means of doing?

A)Start transactions
B)Rollback transactions
C)Read a Microsoft Word document
D)Issue SQL commands

Question 68

A data source that is local to a single computer and can be used by the operating system and any user on that computer is called a ________ data source.

A)file
B)user
C)shared
D)system

Question 69

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

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

Question 70

Which of the following is a function performed by the driver manager in ODBC?

A)Submit SQL statements to the data source
B)Determine the type of DBMS that processes a given ODBC data source
C)Load the appropriate ODBC driver into memory
D)Both B and C are correct

Question 71

In general,for Web applications it is best to create what type of data source on the Web server?

A)File
B)User
C)Shared
D)System

Question 72

OLE DB breaks the features and functions of a DBMS into what type of objects?

A)COM
B)JSP
C)MTS
D)ODBC

Question 73

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

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

Question 74

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

Question 75

Which of the following is not true about OLE DB?

A)Scripting languages can access OLE DB.
B)OLE DB is object-oriented.
C)OLE DB can access ODBC data sources.
D)OLE DB can access non-relational data sources.

Question 76

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

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

Question 77

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

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 78

Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver?

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

Question 79

Which of the following is true about ODBC?

A)ODBC has experienced little practical success.
B)ODBC requires developers to have a thorough knowledge of many DBMS native libraries.
C)ODBC can be used to access data from spreadsheets.
D)ODBC has an object-oriented interface.

Question 80

The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.