ODBC, OLE DB, ADO, AND ASP QUIZ

In OLE DB, a tabular data provider:

exposes data via rowsets.

does not own data.

transforms data through ODE DB interfaces.

is both a consumer and a provider of data.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC minimum SQL grammar contains which of the following?

CREATE VIEW, DROP VIEW only

Literals for date, time and timestamp only

INSERT, UPDATE, DELETE only

Stored Procedures only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A data source is an ODBC data structure that identifies a database and the DBMS that processes it.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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 : ?

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

ASP

ODBC

ADO

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB tabular data providers present data in the form of rowsets.

True

False

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 : ?

↑