Practice ODBC, OLE DB, ADO, And ASP Multiple Choice Questions Quiz-2 - MCQGeeks.com

Q.1

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

True
False

Q.2

In OLE DB, a tabular data provider:

does not own data.
transforms data through ODE DB interfaces.
is both a consumer and a provider of data.
exposes data via rowsets.

Q.3

The ODBC Level 2 API contains which the following functions?

Commit or rollback transactions only
Connect to data sources with driver-specific information only
Connect to data sources only
All of the above are contained in the OBDC Level 2 API

Q.4

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

system data source.
file data source.
user data source.
SQL text file.

Q.5

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

ODBC
ASP
JPCD
ADO

Q.6

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

system data source.
file data source.
user data source.
SQL text file.

Q.7

________ is an object-oriented interface that encapsulates data-server functionality.

ODBC
OLE DB
JPCD
ADO

Q.8

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

Data source
Driver
Driver manager
OLE DB

Q.9

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

True
False

Q.10

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

Browse possible connections and data sources only
Connect to data sources with driver-specific information only
Process a scrollable cursor only
Both 1 and 3 above are in the OBDC Level 1 API

Q.11

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

ODBC
OLE DB
JPCD
ADO

Q.12

________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.

ODBC
OLE DB
JPCD
ADO

Q.13

Which of the following are goals of OLE DB?

Create object interfaces for DBMS functionality pieces only.
Increase flexibility only.
Object interface over any type of data only.
All of the above as goals of OLE DB.

Q.14

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

data source.
driver manager.
driver.
API.

Q.15

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

properties.
collections.
methods.
abstractions.

0 h : 0 m : 1 s