ODBC, OLE, ADO, and ASP - Practice Questions

Question 1

ODBC minimum SQL grammar contains which of the following?

Accepted Answer

Question 2

ODBC core SQL grammar contains which of the following?:

Accepted Answer

Question 3

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

Accepted Answer

Question 4

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

Accepted Answer

Question 5

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

Accepted Answer

Question 6

In OLE DB, a service provider:

Accepted Answer

Question 7

The ODBC Level 2 API contains which the following functions?

Accepted Answer

Question 8

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

Accepted Answer

Question 9

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

Accepted Answer

Question 10

In OLE DB, which of the following represents characteristics of the recordset abstraction?

Accepted Answer