ODBC, OLE DB, ADO, AND ASP QUIZ

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

ODBC

OLE DB

JPCD

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a cover for utilizing OLE DB that is designed for use by almost any language.

ADO

JPCD

ODBC

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC core SQL grammar contains which of the following?:

INSERT, UPDATE, DELETE only

Stored procedures only

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

Full SELECT (includes subqueries) only

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Commit or rollback transactions only

All of these

Connect to data sources with driver-specific information only

Connect to data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

ODBC

ADO

XML

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑