ODBC, OLE DB, ADO, AND ASP QUIZ

A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Connect to data sources only

Commit or rollback transactions only

Connect to data sources with driver-specific information only

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Driver

Driver manager

Data source

DBMS

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

does not own data only.

transforms data through OLE DB interfaces only.

is both a consumer and a provider of data only.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC minimum SQL grammar contains which of the following?

Literals for date, time and timestamp only

Stored Procedures only

INSERT, UPDATE, DELETE only

CREATE VIEW, DROP VIEW only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ODBC

OLE DB

JPCD

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

OLE DB

ODBC

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Users of OLE DB functionality are referred to as data providers.

False

True

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑