PHYSICAL DATABASE DESIGN QUIZ

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

SQL text file.

system data source.

user data source.

file data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC is a foundation of data access in the specifically Microsoft world.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An OLE DB rowset is equivalent to a cursor.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLE DB

ODBC

JPCD

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 1 API contains which of the following functions?

Connect to data sources with driver-specific information only

Browse possible connections and data sources only

Process a scrollable cursor only

Both 1 and 3 above are in the OBDC Level 1 API

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.

XML

ODBC

ASP

ADO

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The ODBC Level 2 API contains which the following functions?

Connect to data sources only

Commit or rollback transactions only

All of these

Connect to data sources with driver-specific information only

TRUE ANSWER : ?
YOUR ANSWER : ?

↑