ODBC, OLE DB, ADO, AND ASP QUIZ

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

ADO

XML

ODBC

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Methods

Abstractions

Properties

Collections

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC core API consists of which of the following functions?

Both 1 and 3 above are in the OBDC core API

Commit or rollback transactions only

Connect to data sources only

Connect to data sources with driver-specific information only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

system data source.

SQL text file.

file data source.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, actions that an object can perform are called:

collections.

methods.

properties.

abstractions.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Process a scrollable cursor only

Browse possible connections and data sources only

Connect to data sources with driver-specific information only

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

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.

Full SELECT (includes subqueries) only

Stored procedures only

INSERT, UPDATE, DELETE only

TRUE ANSWER : ?
YOUR ANSWER : ?