Question 1 of 25
Hints left: 3
Q1
ODBC is a foundation of data access in the specifically Microsoft world.
Q2
A OLE DB collection is an object that contains a group of other objects.
Q3
An abstraction is a generalization of something.
Q4
The ODBC Level 2 API contains which the following functions?
Q5
The ADO connection object is created after the ADO errors object is created.
Q6
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
Q7
OLE DB tabular data providers present data in the form of rowsets.
Q8
ODBC identifies two types of drivers: single tier and multiple-tier.
Q9
Users of OLE DB functionality are referred to as data providers.
Q10
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
Q11
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
Q12
In ODBC, a data source that is local to a single computer is called a:
Q13
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.
Q14
A user data source is one that can be shared among database users.
Q15
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
Q16
The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
Q17
In OLE DB, a tabular data provider:
Q18
OLE DB has two types of data providers: tabular data providers and service providers.
Q19
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
Q20
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
Q21
In OLE DB, a service provider:
Q22
A file data source is one that is local to a single computer.
Q23
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
Q24
An OLE DB rowset is equivalent to a cursor.
Q25
A data source is an ODBC data structure that identifies a database and the DBMS that processes it.