ISE 224 Chapter 11
c
ADO.NET in-memory databases are called ________. A) adoBases B) adoDatabases C) DataSets D) dotNetDatabases
c
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
a
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
c
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.
b
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? A) Only Type 1 and Type 2 B) All four Types C) Only Type 3 and Type 4 D) Only Type 2 and Type 3
d
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
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
c
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
c
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
c
The actions that an object can perform are called ________. A) procedures B) collections C) methods D) properties
d
The characteristics of an object are called ________. A) classes B) collections C) methods D) properties
a
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
false
True or false, ADO is accessible for languages such as C++ and C#, but not Visual Basic or scripting languages
true
True or false, ADO provides access to OLE functionally to programming languages that ordinarily could not access OLE functions
true
True or false, ADO was (and still is) frequently used for database applicaitons
false
True or false, ADO.NET is a completely new product, with no connection to ADO except the similar name
true
True or false, ADO.NET provides the capability to create and process in-memory databases called DataSets
true
True or false, HTML is an application of a document markup language called Standard Generalized Markup Language (SGML)
true
True or false, HTML is defined by the World Wide Web Consortium (W3C)
false
True or false, JDBC drivers only exist for a limited number of DBMS products at this time
true
True or false, JDBC-ODBC bridge drivers resolve inconsistencies between Java and C/C++ to allow Java access to ODBC data sources
true
True or false, JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the compiled version of the page
false
True or false, Java Server Pages (JSP) can run only on Linux or Unix servers
true
True or false, Java programs are compiled into machine-independent bytecode
false
True or false, Java programs that access a database from an applet must use a Type 2 JDBC driver
false
True or false, MySQL does not have facilities for generating XML documents from database data
false
True or false, ODBC has not had practical success, but has shown great potential for future development
true
True or false, ODBC stands for Open Database Connectivity
true
True or false, ODBC works with table-like data sources such as relational databases and spreadsheets
true
True or false, OLE DB can act as a wrapper for (covers) database native libraries so that the functionality can be provided by OLE
true
True or false, OLE DB can be used to access ODBC data sources
true
True or false, OLE DB is an object-oriented interface
true
True or false, OLE DB objects are COM objects
true
True or false, Oracle requires the use of Java for generating XML documents from database data
true
True or false, PHP code is executed on a server and can generate HTML code that is sent to the client computer
true
True or false, SOAP was originally an XML-based standard for providing remote procedure calls over the Internet
true
True or false, XML documents can be automatically generate from database data
false
True or false, XML provides a standardized, non-customizable way to describe the content of a document
false
True or false, a common default Web page name recognized by most Web servers is FirstPage.html
true
True or false, a multiple-tier ODBC driver may reformat an SQL request, but it does not actually process the SQL statement
true
True or false, an ADO.NET DataSet has all the characteristics, features, and functions of a regular database
false
True or false, an ADO.NET DataSet is connected to databases
false
True or false, an ADO.NET dataset can have primary and foreign keys, but ADO.NET does not support referential integrity
true
True or false, an ADO.NET dataset can only be used with optimistic locking
true
True or false, an OLE DB service provider accepts data from an OLE DB tabular data provider
false
True or false, an applet is a Java bytecode program that executes on the Web server
true
True or false, applet bytecode is sent to the user's computer and is invoked using the HTTP protocol
true
True or false, basic web pages are created using Hypertext Markup Language (HTML)
false
True or false, database processing and document processing are unrelated to one another
true
True or false, every DBMS product has an application programming interface (AP)
false
True or false, every DBMS product uses the same API
true
True or false, if a server is using a Microsoft Windows operating system, it is usually running Internet Information Server (IIS) as its Web server
false
True or false, if the web server and the DBMS are running on the same server, the system has a three-tier architecture
true
True or false, in ODBC, the amount of work that the driver must do is largely determined by the degree of SQL-compliance of the data source
false
True or false, in OLE DB, a RecordSet is a more abstract representation of a rowset
false
True or false, in OLE DB, all of an object's properties must be exposed in all interfaces, but not all methods have to be exposed
true
True or false, in general, the best type of ODBC data source to define for a Web application is a system data source
false
True or false, in the 1990s, the database community and the document processing community created a standard called Expandable Markup Language (XML)
false
True or false, java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode
true
True or false, object classes have properties that represent characteristics of the objects in the class
true
True or false, once an ADO.NET dataset is constructed, its contents can be formatted as an XML document with a single command
true
True or false, one important result of OLE DB is that data does not have to be moved or converted from one form to another
true
True or false, one of the properties of all the collections is Count, which is the number of objects in the collection
false
True or false, only open source products may be used in conjunction with JDBC
true
True or false, the SQL Server statement SELECT...FROM XML RAW tells SQL Server to place the data values from the columns in the table into XML elements
false
True or false, the first step in using a JDBC driver is to establish a connection
false
True or false, the most widely used Web server for all operating systems is Internet Information Services (IIS)
true
True or false, to use JDBC, programs must be written in Java
false
True or false, type 2 JDBC drivers access ODBC data sources over a network
false
True or false, type 4 JDBC drivers translate JDBC calls into a DBMS-independetn network protocol
true
True or false, with ODBC, a database and the DBMS that processes it are identified by the data source
false
True or false, with ODBC, a file data source is available only to the user that created it
false
True or false, with ODBC, only a single driver is needed to handle all data source types, such as Oracle, DB2, and Access
true
True or false, with ODBC, the driver manager serves as an intermediary between the application and the DBMS drivers
b
What type of JDBC driver connects to the native API of the DBMS? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver
a
What type of JDBC driver is known as a JDBC-ODBC bridge? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver
c
What type of JDBC driver translates JDBC calls into DBMS-independent network protocols? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver
d
What type of JDBC driver translates JDBC calls into DBMS-specific network protocols? A) Type 1 driver B) Type 2 driver C) Type 3 driver D) Type 4 driver
c
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
b
Which of the following can only interact with relational database and table-like data structures? A) OLE DB B) ODBC C) ASP D) ADO
d
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
c
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
d
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
d
Which of the following is not 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) Operations performed on DataSets are also performed on the data on disk.
d
Which of the following is not 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) Microsoft does not supply a data provider for Oracle database.
a
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.
b
Which of the following is not true about bytecode interpretation? A) It may be performed on the client or the server. B) Only one bytecode interpreter is needed for all machine architectures. C) It is slower than running a program compiled into machine code. D) It increases portability.
c
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#.
c
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.
a
Which of the following is true of JDBC? A) Programs must be written in Java. B) JDBC only works with open-source products. C) JDBC is only available for Unix-like operating systems, such as Linux. D) JDBC is actually a DBMS.
a
Which standard interface in OLE DB is invoked to declare a forward-only cursor? A) IRowSet B) IAccessor C) IColumnsInfo D) adXact
c
A(n) ________ is a Java program that is interpreted and executed by a bytecode interpreter on the Web server. A) applet B) Java virtual machine C) servlet D) JDBC translator
c
A Java virtual machine is actually a ________. A) program compiler B) JDBC data source C) bytecode interpreter D) JDBC driver
a
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
b
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
d
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
b
A set of objects and the properties and methods that they expose are known as a(n) ________. A) provider B) interface C) implementation D) instantiation
a
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
c
Applet bytecode is transmitted to the user's computer via ________. A) the JDBC driver B) the Java virtual machine C) HTTP D) the bytecode interpreter
a
OLE DB breaks the features and functions of a DBMS into what type of objects? A) COM B) JSP C) MTS D) ODBC
