________ 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.
In OLE DB, a service provider:
In OLE DB, a service provider:
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.
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.
ODBC minimum SQL grammar contains which of the following?
ODBC minimum SQL grammar contains which of the following?
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.
ODBC is a foundation of data access in the specifically Microsoft world.
ODBC is a foundation of data access in the specifically Microsoft world.
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.
Which of the following are goals of OLE DB?
Which of the following are goals of OLE DB?
The ODBC Level 1 API contains which of the following functions?
The ODBC Level 1 API contains which of the following functions?
In OLE DB, a tabular data provider:
In OLE DB, a tabular data provider:
The ODBC Level 2 API contains which the following functions?
The ODBC Level 2 API contains which the following functions?
In OLE DB, actions that an object can perform are called:
In OLE DB, actions that an object can perform are called:
________ 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.
An OLE DB rowset is equivalent to a cursor.
An OLE DB rowset is equivalent to a cursor.
ODBC core SQL grammar contains which of the following?:
ODBC core SQL grammar contains which of the following?:
The ODBC core API consists of which of the following functions?
The ODBC core API consists of which of the following functions?
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.
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.
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.
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 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.
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?
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.
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):
________ 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.
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.
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:
Users of OLE DB functionality are referred to as data providers.
Users of OLE DB functionality are referred to as data providers.
An abstraction is a generalization of something.
An abstraction is a generalization of something.
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?
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?
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:
________ is an object-oriented interface that encapsulates data-server functionality.
________ is an object-oriented interface that encapsulates data-server functionality.
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.
________ 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.
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.
ODBC identifies two types of drivers: single tier and multiple-tier.
ODBC identifies two types of drivers: single tier and multiple-tier.
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.
OLE DB tabular data providers present data in the form of rowsets.
OLE DB tabular data providers present data in the form of rowsets.
