ODBC, OLE DB, ADO, AND ASP QUIZ

A OLE DB collection is an object that contains a group of other objects.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Commit or rollback transactions only

Connect to data sources with driver-specific information only

All of these

Connect to data sources only

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC minimum SQL grammar contains which of the following?

Literals for date, time and timestamp only

INSERT, UPDATE, DELETE only

Stored Procedures 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.

JPCD

ODBC

ADO

OLE DB

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

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

Which of the following are goals of OLE DB?

Object interface over any type of data only.

All of these

Increase flexibility only.

Create object interfaces for DBMS functionality pieces only.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑