ODBC, OLE DB, ADO, AND ASP QUIZ

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC core SQL grammar contains which of the following?:

Both 1 and 3 above are contained in the ODBC core SQL.

Stored procedures only

INSERT, UPDATE, DELETE only

Full SELECT (includes subqueries) only

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Object interface over any type of data only.

All of these

Increase flexibility only.

Create object interfaces for DBMS functionality pieces only.

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a tabular data provider:

exposes data via rowsets.

is both a consumer and a provider of data.

transforms data through ODE DB interfaces.

does not own data.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

ADO

ODBC

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Methods

Collections

Properties

Abstractions

TRUE ANSWER : ?
YOUR ANSWER : ?

The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

file data source.

system data source.

user data source.

SQL text file.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

ODBC

ADO

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

↑