ODBC, OLE DB, ADO, AND ASP QUIZ

The ODBC Level 1 API contains which of the following functions?

Connect to data sources with driver-specific information only

Both 1 and 3 above are in the OBDC Level 1 API

Process a scrollable cursor only

Browse possible connections and data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

ASP

ODBC

ADO

XML

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a cover for utilizing OLE DB that is designed for use by almost any language.

JPCD

ADO

ODBC

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The ADO connection object is created after the ADO errors object is created.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Connect to data sources only

All of these

Connect to data sources with driver-specific information only

Commit or rollback transactions only

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB has two types of data providers: tabular data providers and service providers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is an object-oriented interface that encapsulates data-server functionality.

JPCD

ODBC

ADO

OLE DB

TRUE ANSWER : ?
YOUR ANSWER : ?

↑