ODBC, OLE DB, ADO, AND ASP QUIZ

The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

SQL text file.

user data source.

system data source.

file data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

ODBC

JPCD

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

ADO

JPCD

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC core SQL grammar contains which of the following?:

INSERT, UPDATE, DELETE only

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

Stored procedures only

Full SELECT (includes subqueries) only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Connect to data sources with driver-specific information only

Both 1 and 3 above are in the OBDC core API

Commit or rollback transactions only

Connect to data sources only

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB rowset is equivalent to a cursor.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A file data source is one that is local to a single computer.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑