Database

Database

ODBC, OLE DB, ADO, and ASP has 40 Questions
ODBC minimum SQL grammar contains which of the following?

INSERT, UPDATE, DELETE only
Stored Procedures only
Literals for date, time and timestamp only
CREATE VIEW, DROP VIEW only
A file data source is one that is local to a single computer.

True
False
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?

Data source
Driver
Driver manager
DBMS
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

True
False
The ODBC core API consists of which of the following functions?

Commit or rollback transactions only
Connect to data sources with driver-specific information only
Connect to data sources only
Both 1 and 3 above are in the OBDC core API.
An OLE DB rowset is equivalent to a cursor.

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

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

True
False
ODBC core SQL grammar contains which of the following?:

INSERT, UPDATE, DELETE only
Stored procedures only
Full SELECT (includes subqueries) only
Both 1 and 3 above are contained in the ODBC core SQL.
An abstraction is a generalization of something.

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

ODBC
OLE DB
JPCD
ADO
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

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

ODBC
OLE DB
JPCD
ADO
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.

True
False
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.
ODBC identifies two types of drivers: single tier and multiple-tier.

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

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

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

properties.
collections.
methods.
abstractions.
Users of OLE DB functionality are referred to as data providers.

True
False
In OLE DB, which of the following represents characteristics of the recordset abstraction?

Properties
Collections
Methods
Abstractions
A user data source is one that can be shared among database users.

True
False
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.
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.

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

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

True
False
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
The ADO connection object is created after the ADO errors object is created.

True
False
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.
The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.

True
False
In OLE DB, a service provider:

does not own data only.
transforms data through OLE DB interfaces only.
is both a consumer and a provider of data only.
All of the above are true of an OLE DB service provider.
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.

True
False
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.
A OLE DB collection is an object that contains a group of other objects.

True
False
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
OLE DB has two types of data providers: tabular data providers and service providers.

True
False
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.
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

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

ODBC
ASP
JPCD
ADO
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

True
False