ODBC, OLE DB, ADO, AND ASP QUIZ

A user data source is one that can be shared among database users.

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

In OLE DB, a tabular data provider:

is both a consumer and a provider of data.

transforms data through ODE DB interfaces.

does not own data.

exposes data via rowsets.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

collections.

abstractions.

methods.

properties.

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

DBMS

Driver manager

Data source

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, a service provider:

transforms data through OLE DB interfaces only.

is both a consumer and a provider of data only.

does not own data only.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

ODBC

ADO

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC core SQL grammar contains which of the following?:

Stored procedures only

INSERT, UPDATE, DELETE only

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

Full SELECT (includes subqueries) only

TRUE ANSWER : ?
YOUR ANSWER : ?

↑