ODBC, OLE DB, ADO, and ASP – General Questions

6. ________ is considered to be one of the foundations of data access in the Microsoft world.

A. ODBC
B. OLE DB
C. JPCD
D. ADO

Correct Answer:  B. OLE DB

7. ________ is an interface by which application programs can access and process SQL databases in a DBMSindependent manner.

A. ODBC
B. OLE DB
C. JPCD
D. ADO

Correct Answer:  A. ODBC

8. Which of the following are goals of OLE DB?

A. Create object interfaces for DBMS functionality pieces only.
B. Increase flexibility only.
C. Object interface over any type of data only.
D. All of the above as goals of OLE DB

Correct Answer:  D. All of the above as goals of OLE DB

9. An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):

A. data source.
B. driver manager.
C. driver.
D. API.

Correct Answer:  A. data source.

10. In OLE DB, actions that an object can perform are called:

A. properties.
B. collections.
C. methods.
D. abstractions.

Correct Answer:  C. methods.

Leave A Comment?

18 + 17 =