Machine-translated by Google. Questions are authored in English.
Top

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

1.

ODBC minimum SQL grammar contains which of the following?

Answer: A

Correct answer: INSERT, UPDATE, DELETE only

The minimum grammar is the smallest set a driver must support to be ODBC compliant: the data manipulation statements, simple CREATE TABLE and DROP TABLE, a simple SELECT, and the basic expressions. Views and stored procedures belong to the core and extended grammars respectively, which is how the three conformance levels are graded.

Please log in or register to report this question.

Discuss in Forum
2.

When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?

Answer: B

Correct answer: Driver

The driver is the DBMS-specific component: it receives an ODBC request and translates it into statements the particular data source understands, then translates the results back. The driver manager sits above it and chooses which driver to load, and the data source names the database and the DBMS that processes it.

Please log in or register to report this question.

Discuss in Forum
3.

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

Answer: D

Correct answer: Both 1 and 3 above are in the OBDC core API.

The core API covers the basics every driver must provide: connecting to and disconnecting from data sources, preparing and executing SQL, retrieving results, and committing or rolling back transactions. Connecting with driver-specific information belongs to Level 1, and browsing available connections and scrollable cursors to Level 2.

Please log in or register to report this question.

Discuss in Forum
4.

________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

Answer: D

Correct answer: ADO

ADO, ActiveX Data Objects, is a thin object model over OLE DB with only a handful of objects - connection, command, recordset, errors - which makes it far easier to learn than OLE DB itself. Its purpose is to make OLE DB reachable from scripting languages and from ordinary application code without the complexity of the underlying COM interfaces.

Please log in or register to report this question.

Discuss in Forum
5.

ODBC core SQL grammar contains which of the following?:

Answer: D

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

The core grammar takes in everything in the minimum grammar and adds the full SELECT with subqueries, CREATE VIEW and DROP VIEW, GRANT and REVOKE, and the standard aggregate functions. Stored procedures are in the extended grammar, one level above.

Please log in or register to report this question.

Discuss in Forum
6.

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

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.

Please log in or register to report this question.

Discuss in Forum
7.

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

Answer: A

Correct answer: ODBC

ODBC, Open Database Connectivity, is the standard interface by which a program issues SQL to any compliant DBMS without knowing which one it is talking to. The independence is achieved by the driver, which translates the standard calls into whatever the particular DBMS requires, so the application itself needs no change to move between products.

Please log in or register to report this question.

Discuss in Forum
8.

Which of the following are goals of OLE DB?

Answer: D

Correct answer: All of the above as goals of OLE DB.

All three were stated aims. Breaking DBMS functionality into object interfaces means a provider need implement only the pieces it can support; that flexibility lets a simple source expose a little and a full DBMS expose a great deal; and putting an object interface over any type of data extends the model beyond relational databases to spreadsheets, mail stores and files.

Please log in or register to report this question.

Discuss in Forum
9.

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

Answer: A

Correct answer: data source.

A data source is the ODBC data structure that names both the database and the DBMS that processes it, together with whatever else is needed to reach it. It is what an application connects to by name, and the indirection is the point: change which database the name refers to and the application follows without being recompiled.

Please log in or register to report this question.

Discuss in Forum
10.

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

Answer: C

Correct answer: methods.

In the object model an object has properties, which are the characteristics it exposes, and methods, which are the actions it can perform. A collection is an object that contains a group of other objects. The vocabulary matters because an OLE DB interface is defined precisely as the set of objects it exposes together with their properties and methods.

Please log in or register to report this question.

Discuss in Forum
Loading…

Topics

Other Subjects

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

About Us

ExamsRepo

Copyright © 2026 ExamsRepo . All Rights Reserved . With