ODBC, OLE, ADO, and ASP Questions and Answers

Practice Mode
Showing 10 of 20 questions
Q11
In OLE DB, which of the following represents characteristics of the recordset abstraction?
  • A Properties
  • B Collections
  • C Methods
  • D Abstractions
Answer: Option A
Q12
In ODBC, a file that can be shared among database users is called a:
  • A system data source.
  • B file data source.
  • C user data source.
  • D SQL text file.
Answer: Option B
Q13
13.  ________ is an object-oriented interface that encapsulates data-server functionality.
  • A ODBC
  • B OLE DB
  • C JPCD
  • D ADO
Answer: Option B
Q14
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
  • A Data source
  • B Driver
  • C Driver manager
  • D OLE DB
Answer: Option C
Q15
The ODBC Level 1 API contains which of the following functions?
  • A Browse possible connections and data sources only
  • B Connect to data sources with driver-specific information only
  • C Process a scrollable cursor only
  • D Both 1 and 3 above are in the OBDC Level 1 API.
Answer: Option B
Q16
In OLE DB, a service provider:
  • A does not own data only.
  • B transforms data through OLE DB interfaces only.
  • C is both a consumer and a provider of data only.
  • D All of the above are true of an OLE DB service provider.
Answer: Option D
Q17
In OLE DB, a tabular data provider:
  • A does not own data.
  • B transforms data through ODE DB interfaces.
  • C is both a consumer and a provider of data.
  • D exposes data via rowsets.
Answer: Option D
Q18
The ODBC Level 2 API contains which the following functions?
  • A Commit or rollback transactions only
  • B Connect to data sources with driver-specific information only
  • C Connect to data sources only
  • D All of the above are contained in the OBDC Level 2 API
Answer: Option D
Q19
In ODBC, a data source that is local to a single computer is called a:
  • A system data source.
  • B file data source.
  • C user data source.
  • D SQL text file.
Answer: Option A
Q20
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
  • A ODBC
  • B ASP
  • C JPCD
  • D ADO
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test