ODBC, OLE DB, ADO, AND ASP QUIZ

In ODBC, a file that can be shared among database users is called a:

user data source.

file data source.

system data source.

SQL text file.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC core SQL grammar contains which of the following?:

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

INSERT, UPDATE, DELETE only

Stored procedures only

Full SELECT (includes subqueries) only

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

All of these

Object interface over any type of data only.

Increase flexibility only.

Create object interfaces for DBMS functionality pieces only.

TRUE ANSWER : ?
YOUR ANSWER : ?

An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):

driver manager.

driver.

API.

data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC minimum SQL grammar contains which of the following?

INSERT, UPDATE, DELETE only

CREATE VIEW, DROP VIEW only

Stored Procedures only

Literals for date, time and timestamp only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

file data source.

user data source.

SQL text file.

system data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

An abstraction is a generalization of something.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

JPCD

ASP

ADO

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑