ODBC, OLE DB, ADO, AND ASP QUIZ

Which of the following are goals of OLE DB?

Object interface over any type of data only.

Increase flexibility only.

All of these

Create object interfaces for DBMS functionality pieces only.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

properties.

abstractions.

methods.

collections.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC minimum SQL grammar contains which of the following?

Literals for date, time and timestamp only

CREATE VIEW, DROP VIEW only

INSERT, UPDATE, DELETE only

Stored Procedures only

TRUE ANSWER : ?
YOUR ANSWER : ?

In ODBC, a data source that is local to a single computer is called a:

file data source.

system data source.

SQL text file.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

ADO

OLE DB

ODBC

JPCD

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ADO connection object is created after the ADO errors object is created.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

ADO

ODBC

XML

ASP

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑