Deck 11: The Web Server Environment

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

Every DBMS product uses the same API.

Question 5

OLE DB is an object-oriented interface.

Question 6

ODBC acts as a wrapper for OLE DB.

Question 7

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

Question 8

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

Question 9

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

Question 10

OLE DB can be used to access ODBC data sources.

Question 11

OLE DB objects are COM objects.

Question 12

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

Question 13

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

Question 14

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

Question 15

ODBC stands for Open Database Connectivity.

Question 16

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 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

An ADO.NET DataSet is connected to databases.

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

To use JDBC,programs must be written in Java.

Question 41

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

Question 42

XML designers created a system that allows document structure,data content,and materialization to be mixed.

Question 43

Database processing and document processing are unrelated to one another.

Question 44

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

Question 45

Java programs are compiled into machine-independent bytecode.

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

JSP can be coded only in Java and JavaScript.

Question 53

DTD stands for Document Type Declaration.

Question 54

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

Question 55

Unlike SQL views,XML views are not limited to one multivalued path.

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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 61

XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.

Question 62

XML documents that conform to an XML Schema are validated against that schema.

Question 63

XML Schema is a synonym for Document Type Declaration (DTD).

Question 64

After an XSLT processor transforms an XML document into an HTML document,the HTML document is materialized using a browser.

Question 65

An XSLT stylesheet is used by XSLT to indicate how to transform the elements of an XML document into another format.

Question 66

XML documents that conform to their DTD are said to be type-valid XML documents.

Question 67

An XSLT command embedded in the structure of an XSLT stylesheet is of the form {loop,action}.

Question 68

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

Question 69

The first statement of an XML document indicates the schema that will be used to validate the document.

Question 70

XSLT is a declarative transformation language.

Question 71

XML documents that do not conform to their DTD are said to be non-type-valid XML documents.

Question 72

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

Question 73

XSLT is a non-declarative transformation language.

Question 74

In XML Schema,there are two types of elements,simple and composite.

Question 75

XML Schemas consist of elements,attributes,and properties.

Question 76

All type-valid XML documents are required to have a DTD.

Question 77

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

Question 78

XML documents and XML Schemas are created in different languages.

Question 79

Most of today's Web browsers still lack a built-in XSLT processor.

Question 80

XSLT processors are context oriented;that is,each statement is evaluated within the context of the match that has already been made.