ODBC, OLE DB, ADO, AND ASP QUIZ

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

OLE DB

Driver

Driver manager

Data source

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 is a foundation of data access in the specifically Microsoft world.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

JPCD

OLE DB

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLE DB, which of the following represents characteristics of the recordset abstraction?

Abstractions

Properties

Methods

Collections

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Increase flexibility only.

Object interface over any type of data only.

All of these

Create object interfaces for DBMS functionality pieces only.

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

A file data source is one that is local to a single computer.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑