A file data source is one that is local to a single computer.
Select an option to see the answer and solution.
Database · all questionsODBC, OLE DB, ADO, and ASP
ODBC, OLE DB, ADO, and ASP
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
Select an option to see the answer and solution.
An OLE DB rowset is equivalent to a cursor.
Select an option to see the answer and solution.
ODBC is a foundation of data access in the specifically Microsoft world.
Select an option to see the answer and solution.
An abstraction is a generalization of something.
Select an option to see the answer and solution.
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
Select an option to see the answer and solution.
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
Select an option to see the answer and solution.
ODBC identifies two types of drivers: single tier and multiple-tier.
Select an option to see the answer and solution.
A data source is an ODBC data structure that identifies a database and the DBMS that processes it.
Select an option to see the answer and solution.
Users of OLE DB functionality are referred to as data providers.
Select an option to see the answer and solution.
A user data source is one that can be shared among database users.
Select an option to see the answer and solution.
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
Select an option to see the answer and solution.
OLE DB tabular data providers present data in the form of rowsets.
Select an option to see the answer and solution.
The ADO connection object is created after the ADO errors object is created.
Select an option to see the answer and solution.
The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
Select an option to see the answer and solution.
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
Select an option to see the answer and solution.
A OLE DB collection is an object that contains a group of other objects.
Select an option to see the answer and solution.
OLE DB has two types of data providers: tabular data providers and service providers.
Select an option to see the answer and solution.
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
Select an option to see the answer and solution.
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.
Select an option to see the answer and solution.