ODBC core SQL grammar contains which of the following?:
ODBC core SQL grammar contains which of the following?:
________ 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.
Which of the following are goals of OLE DB?
Which of the following are goals of OLE DB?
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 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.
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 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.
________ 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.
Users of OLE DB functionality are referred to as data providers.
Users of OLE DB functionality are referred to as data providers.
________ is an object-oriented interface that encapsulates data-server functionality.
________ is an object-oriented interface that encapsulates data-server functionality.
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.
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.
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?
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 identifies two types of drivers: single tier and multiple-tier.
ODBC identifies two types of drivers: single tier and multiple-tier.
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.
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 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.
The ODBC Level 2 API contains which the following functions?
The ODBC Level 2 API contains which the following functions?
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.
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.
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?
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.
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.
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.
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.
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.
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:
ODBC minimum SQL grammar contains which of the following?
ODBC minimum SQL grammar contains which of the following?
In OLE DB, a service provider:
In OLE DB, a service provider:
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.
An abstraction is a generalization of something.
An abstraction is a generalization of something.
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.
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:
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.
