ODBC, OLE DB, ADO, AND ASP QUIZ

A OLE DB collection is an object that contains a group of other objects.

False

True

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?

DBMS

Driver

Driver manager

Data source

TRUE ANSWER : ?
YOUR ANSWER : ?

ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Abstractions

Methods

Collections

Properties

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

All of these

is both a consumer and a provider of data only.

transforms data through OLE DB interfaces only.

does not own data only.

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑