ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC core SQL grammar contains which of the following?:

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

Stored procedures only

Full SELECT (includes subqueries) only

INSERT, UPDATE, DELETE 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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

does not own data only.

All of these

is both a consumer and a provider of data only.

transforms data through OLE DB interfaces only.

TRUE ANSWER : ?
YOUR ANSWER : ?

The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In ODBC, a data source that is local to a single computer is called a:

system data source.

SQL text file.

file data source.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

JPCD

ODBC

OLE DB

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

Which of the following are goals of OLE DB?

Object interface over any type of data only.

Create object interfaces for DBMS functionality pieces only.

All of these

Increase flexibility only.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑