ODBC, OLE DB, ADO, and ASP - Database MCQ Questions and answers- Technical Aptitude Page-2 section-1

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

A. Properties

B. Collections

C. Methods

D. Abstractions

Answer & Solution Discuss in Board Save for Later

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

A. system data source.

B. file data source.

C. user data source.

D. SQL text file.

Answer & Solution Discuss in Board Save for Later

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

A. ODBC

B. OLE DB

C. JPCD

D. ADO

Answer & Solution Discuss in Board Save for Later

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

A. Data source

B. Driver

C. Driver manager

D. OLE DB

Answer & Solution Discuss in Board Save for Later

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

A. Browse possible connections and data sources only

B. Connect to data sources with driver-specific information only

C. Process a scrollable cursor only

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

Answer & Solution Discuss in Board Save for Later

16.
In OLE DB, a service provider:

A. does not own data only.

B. transforms data through OLE DB interfaces only.

C. is both a consumer and a provider of data only.

D. All of the above are true of an OLE DB service provider.

Answer & Solution Discuss in Board Save for Later

17.
In OLE DB, a tabular data provider:

A. does not own data.

B. transforms data through ODE DB interfaces.

C. is both a consumer and a provider of data.

D. exposes data via rowsets.

Answer & Solution Discuss in Board Save for Later

18.
The ODBC Level 2 API contains which the following functions?

A. Commit or rollback transactions only

B. Connect to data sources with driver-specific information only

C. Connect to data sources only

D. All of the above are contained in the OBDC Level 2 API

Answer & Solution Discuss in Board Save for Later

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

A. system data source.

B. file data source.

C. user data source.

D. SQL text file.

Answer & Solution Discuss in Board Save for Later

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

A. ODBC

B. ASP

C. JPCD

D. ADO

Answer & Solution Discuss in Board Save for Later

ODBC, OLE DB, ADO, and ASP - Database MCQ Questions and answers- Technical Aptitude

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

16. In OLE DB, a service provider:

Answer & Solution

17. In OLE DB, a tabular data provider:

Answer & Solution

18. The ODBC Level 2 API contains which the following functions?

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

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

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

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

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

16.
In OLE DB, a service provider:

17.
In OLE DB, a tabular data provider:

18.
The ODBC Level 2 API contains which the following functions?

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

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