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