ODBC, OLE DB, ADO, AND ASP QUIZ

ODBC minimum SQL grammar contains which of the following?

CREATE VIEW, DROP VIEW only

Stored Procedures only

INSERT, UPDATE, DELETE only

Literals for date, time and timestamp only

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

XML

ASP

ODBC

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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 manager

DBMS

Driver

Data source

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Data source

OLE DB

Driver

Driver manager

TRUE ANSWER : ?
YOUR ANSWER : ?

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

user data source.

system data source.

SQL text file.

file data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are goals of OLE DB?

Object interface over any type of data only.

All of these

Create object interfaces for DBMS functionality pieces only.

Increase flexibility only.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑