ODBC, OLE DB, ADO, AND ASP QUIZ

In OLE DB, which of the following represents characteristics of the recordset abstraction?

Properties

Abstractions

Collections

Methods

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 : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In ODBC, a file that can be shared among database users is called a:

system data source.

user data source.

file data source.

SQL text file.

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB tabular data providers present data in the form of rowsets.

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

is both a consumer and a provider of data.

transforms data through ODE DB interfaces.

does not own data.

exposes data via rowsets.

TRUE ANSWER : ?
YOUR ANSWER : ?

In ODBC, a data source that is local to a single computer is called a:

SQL text file.

user data source.

file data source.

system data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?

Driver manager

Driver

DBMS

Data source

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑