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

Browse possible connections and data sources only

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

Process a scrollable cursor only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A file data source is one that is local to a single computer.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.

OLE DB

JPCD

ODBC

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, actions that an object can perform are called:

methods.

abstractions.

collections.

properties.

TRUE ANSWER : ?
YOUR ANSWER : ?

A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

system data source.

file data source.

SQL text file.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB rowset is equivalent to a cursor.

True

False

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

Data source

DBMS

Driver

TRUE ANSWER : ?
YOUR ANSWER : ?

↑