ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC minimum SQL grammar contains which of the following?

Stored Procedures only

Literals for date, time and timestamp only

INSERT, UPDATE, DELETE only

CREATE VIEW, DROP VIEW only

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB rowset is equivalent to a cursor.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Connect to data sources with driver-specific information only

Connect to data sources only

All of these

Commit or rollback transactions only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

ODBC

OLE DB

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

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

XML

ODBC

ASP

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

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

↑