ODBC, OLE DB, ADO, AND ASP QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A data source is an ODBC data structure that identifies a database and the DBMS that processes it.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is considered to be one of the foundations of data access in the Microsoft world.

ODBC

JPCD

OLE DB

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Abstractions

Collections

Properties

Methods

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

In OLE DB, a tabular data provider:

does not own data.

is both a consumer and a provider of data.

transforms data through ODE DB interfaces.

exposes data via rowsets.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

user data source.

file data source.

SQL text file.

system data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑