ODBC, OLE DB, ADO, AND ASP QUIZ

________ is an object-oriented interface that encapsulates data-server functionality.

ADO

OLE DB

ODBC

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

ODBC

JPCD

OLE DB

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

XML

ASP

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

A data source is an ODBC data structure that identifies a database and the DBMS that processes it.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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

Process a scrollable cursor only

Connect to data sources with driver-specific information only

Browse possible connections and data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

file data source.

system data source.

SQL text file.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB tabular data providers present data in the form of rowsets.

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 conformance levels specify which SQL statements, expressions, and data types a driver can process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑