Deck 13: The Web Server Environment

Question 1

OLE DB can be used to access ODBC data sources.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

OLE DB objects are COM objects.

Answer 3

True

Question 4

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

Question 5

The most commonly used Web server on servers running the Unix or Linux operating system is Internet Information Server (IIS).

Question 6

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

Question 7

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

Question 8

ODBC stands for Open Database Connectivity.

Question 9

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

Question 10

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

Question 11

OLE DB is an object-oriented interface.

Question 12

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 13

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

Question 14

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

Question 15

ODBC acts as a wrapper for OLE DB.

Question 16

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

Question 17

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

Question 18

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

Question 19

Every DBMS product uses the same API.

Question 20

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

Question 21

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

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

An ADO.NET DataSet is connected to databases.

Question 24

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

Question 25

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

Question 26

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

Question 27

To use JDBC,programs must be written in Java.

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

A)driver manager
B)OLE DB interface
C)ODBC driver
D)data source
E)database connector

Question 46

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

A)OLE DB
B)ODBC
C)ASP
D)ADO
E)All of the above.

Question 47

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
E)The network platform

Question 48

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

Question 49

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

Question 50

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

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

Question 51

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
E)ODBC translator

Question 52

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 53

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)Verifies the application to the data source
E)Converts the data source into an SQL-compliant data structure

Question 54

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)Convert data source error codes into ODBC error codes
E)B and C

Question 55

Java programs are compiled into machine-independent bytecode.

Question 56

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.
E)ODBC does not include facilities to return error messages.

Question 57

JSP can be coded only in Java and JavaScript.

Question 58

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

Question 59

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

Question 60

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

Question 61

The characteristics of an object are called ________.

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

Question 62

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

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

Question 63

Which of the following is a type of OLE DB data provider?

A)relational data provider
B)method provider
C)sequential data provider
D)tabular data provider
E)implementation provider

Question 64

Which of the following is not true about OLE DB?

A)Scripting languages cannot 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.
E)OLE DB is used as a wrapper for ADO objects.

Question 65

An ADO.NET Data Provider is a(n)________ that provides ADO.NET services.

A)class library
B)windows application
C)web application
D)XML service
E)DND service

Question 66

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
E)Conformance

Question 67

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

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

Question 68

ADO.NET in-memory databases are called ________.

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

Question 69

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)shared
D)system
E)user

Question 70

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
E)Core SQL Grammar

Question 71

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

A)provider
B)data consumer
C)implementation
D)instantiation
E)interface

Question 72

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

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

Question 73

Which of the following is not 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 74

The actions that an object can perform are called ________.

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

Question 75

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

A)COM
B)DBMS
C)MTS
D)ODBC
E)ASP

Question 76

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)common
C)shared
D)system
E)user

Question 77

Which of the following is true about ADO.NET DataSets?

A)They can have multiple tables and relationships.
B)They can have foreign keys and surrogate keys.
C)They can support referential integrity actions.
D)A and B
E)A,B and C

Question 78

Which of the following is true about ADO.NET?

A)It is an improved and expanded version of ADO.
B)It facilitates the transformation of XML documents to and from relational database constructs.
C)It provides the ability to create and process in-memory databases.
D)A and B
E)A,B and C

Question 79

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.
E)It does not have to determine ODBC conformance since all ODBC drivers have the same functionality by definition.

Question 80

Which standard interface in OLE DB is invoked to declare a forward-only cursor?

A)IRowSet
B)IAccessor
C)IColumnsInfo
D)adXact
E)ADODB