ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC minimum SQL grammar contains which of the following?

INSERT, UPDATE, DELETE only

Stored Procedures only

Literals for date, time and timestamp 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 driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A user data source is one that can be shared among database users.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Commit or rollback transactions only

Connect to data sources with driver-specific information only

Connect to data sources only

Both 1 and 3 above are in the OBDC core API

TRUE ANSWER : ?
YOUR ANSWER : ?

Users of OLE DB functionality are referred to as data providers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

True

False

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

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

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

Process a scrollable cursor only

Connect to data sources with driver-specific information only

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

Browse possible connections and data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

↑