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