ODBC, OLE DB, ADO, AND ASP QUIZ

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

Users of OLE DB functionality are referred to as data providers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Create object interfaces for DBMS functionality pieces only.

All of these

Object interface over any type of data only.

Increase flexibility only.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

user data source.

SQL text file.

file data source.

system data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC identifies two types of drivers: single tier and multiple-tier.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):

API.

driver manager.

data source.

driver.

TRUE ANSWER : ?
YOUR ANSWER : ?

A user data source is one that can be shared among database users.

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

↑