An OLE DB rowset is equivalent to a cursor.
An OLE DB rowset is equivalent to a cursor.
A user data source is one that can be shared among database users.
A user data source is one that can be shared among database users.
In OLE DB, which of the following represents characteristics of the recordset abstraction?
In OLE DB, which of the following represents characteristics of the recordset abstraction?
________ is an object-oriented interface that encapsulates data-server functionality.
________ is an object-oriented interface that encapsulates data-server functionality.
In OLE DB, actions that an object can perform are called:
In OLE DB, actions that an object can perform are called:
Which of the following are goals of OLE DB?
Which of the following are goals of OLE DB?
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
In OLE DB, a tabular data provider:
In OLE DB, a tabular data provider:
In ODBC, a data source that is local to a single computer is called a:
In ODBC, a data source that is local to a single computer is called a:
A OLE DB collection is an object that contains a group of other objects.
A OLE DB collection is an object that contains a group of other objects.
In ODBC, a file that can be shared among database users is called a:
In ODBC, a file that can be shared among database users is called a:
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
ODBC core SQL grammar contains which of the following?:
ODBC core SQL grammar contains which of the following?:
ODBC identifies two types of drivers: single tier and multiple-tier.
ODBC identifies two types of drivers: single tier and multiple-tier.
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
In OLE DB, a service provider:
In OLE DB, a service provider:
The ODBC core API consists of which of the following functions?
The ODBC core API consists of which of the following functions?
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
The ODBC Level 2 API contains which the following functions?
The ODBC Level 2 API contains which the following functions?
An abstraction is a generalization of something.
An abstraction is a generalization of something.
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
OLE DB has two types of data providers: tabular data providers and service providers.
OLE DB has two types of data providers: tabular data providers and service providers.
The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
ODBC is a foundation of data access in the specifically Microsoft world.
ODBC is a foundation of data access in the specifically Microsoft world.
________ is considered to be one of the foundations of data access in the Microsoft world.
________ is considered to be one of the foundations of data access in the Microsoft world.
A file data source is one that is local to a single computer.
A file data source is one that is local to a single computer.
The ODBC Level 1 API contains which of the following functions?
The ODBC Level 1 API contains which of the following functions?
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
A data source is an ODBC data structure that identifies a database and the DBMS that processes it.
A data source is an ODBC data structure that identifies a database and the DBMS that processes it.
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
ODBC minimum SQL grammar contains which of the following?
ODBC minimum SQL grammar contains which of the following?
The ADO connection object is created after the ADO errors object is created.
The ADO connection object is created after the ADO errors object is created.
Users of OLE DB functionality are referred to as data providers.
Users of OLE DB functionality are referred to as data providers.
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
OLE DB tabular data providers present data in the form of rowsets.
OLE DB tabular data providers present data in the form of rowsets.
