ODBC, OLE DB, ADO, and ASP Questions and Answers

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

Correct answer: OLE DBOLE DB is the foundation layer in the Microsoft data access stack: an object-oriented, COM-based interface that breaks DBMS functionality into pieces which can be implemented separately and combined. ODBC sits alongside it as the SQL-oriented, cross-platform interface, and ADO sits above OLE DB as a simpler cover for it.

Q: ODBC identifies two types of drivers: single tier and multiple-tier.

Correct answer: TrueODBC does identify exactly these two kinds. A single-tier driver processes both the ODBC calls and the file access itself, which is how a driver for a simple file format such as a spreadsheet works. A multiple-tier driver passes SQL to a separate DBMS, which does the processing, and is the arrangement used for a client-server database.

41.

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

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

Answer: B

Correct answer: OLE DB

OLE DB is the foundation layer in the Microsoft data access stack: an object-oriented, COM-based interface that breaks DBMS functionality into pieces which can be implemented separately and combined. ODBC sits alongside it as the SQL-oriented, cross-platform interface, and ADO sits above OLE DB as a simpler cover for it.

Discuss in Forum

42.

ODBC identifies two types of drivers: single tier and multiple-tier.

A.True
B.False

Answer: B

Correct answer: True

ODBC does identify exactly these two kinds. A single-tier driver processes both the ODBC calls and the file access itself, which is how a driver for a simple file format such as a spreadsheet works. A multiple-tier driver passes SQL to a separate DBMS, which does the processing, and is the arrangement used for a client-server database.

Discuss in Forum

Loading…

Topics

Subject Categories

Tags: ODBC, OLE DB, ADO, and ASP Questions and Answers || ODBC, OLE DB, ADO, and ASP MCQ Questions and Answers || ODBC, OLE DB, ADO, and ASP GK Questions and Answers || ODBC, OLE DB, ADO, and ASP GK MCQ Questions || ODBC, OLE DB, ADO, and ASP Multiple Choice Questions and Answers || ODBC, OLE DB, ADO, and ASP GK || GK on ODBC, OLE DB, ADO, and ASP || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

ODBC, OLE DB, ADO, and ASP Questions and Answers

Topics

Subject Categories

About Us

Stay informed about all important Dates & Notifications