ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC is a foundation of data access in the specifically Microsoft world.

True

False

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

ADO

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

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

In OLE DB, a tabular data provider:

exposes data via rowsets.

transforms data through ODE DB interfaces.

is both a consumer and a provider of data.

does not own data.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Create object interfaces for DBMS functionality pieces only.

All of these

Increase flexibility only.

Object interface over any type of data only.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Properties

Methods

Collections

Abstractions

TRUE ANSWER : ?
YOUR ANSWER : ?

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

driver.

API.

driver manager.

data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 1 API contains which of the following functions?

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

Browse possible connections and data sources only

Process a scrollable cursor only

Connect to data sources with driver-specific information only

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

ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑