ODBC, OLE DB, ADO, AND ASP QUIZ

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

Driver

DBMS

Data source

Driver manager

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

ODBC

ADO

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

ODBC

OLE DB

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC minimum SQL grammar contains which of the following?

INSERT, UPDATE, DELETE only

Stored Procedures only

CREATE VIEW, DROP VIEW only

Literals for date, time and timestamp only

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB has two types of data providers: tabular data providers and service providers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

ASP

ODBC

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

file data source.

SQL text file.

system data source.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑