ODBC, OLE DB, ADO, and ASP problems
- 1. ________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO Discuss
Correct Answer: ODBC
- 2. In OLE DB, a tabular data provider:
Options- 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. Discuss
Correct Answer: exposes data via rowsets.
- 3. ________ is an object-oriented interface that encapsulates data-server functionality.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO Discuss
Correct Answer: OLE DB
- 4. Which of the following are goals of OLE DB?
Options- A. Create object interfaces for DBMS functionality pieces only.
- B. Increase flexibility only.
- C. Object interface over any type of data only.
- D. All of the above as goals of OLE DB. Discuss
Correct Answer: All of the above as goals of OLE DB.
- 5. An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Options- A. data source.
- B. driver manager.
- C. driver.
- D. API. Discuss
Correct Answer: data source.
- 6. In OLE DB, which of the following represents characteristics of the recordset abstraction?
Options- A. Properties
- B. Collections
- C. Methods
- D. Abstractions Discuss
Correct Answer: Properties
- 7. When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Options- A. Data source
- B. Driver
- C. Driver manager
- D. OLE DB Discuss
Correct Answer: Driver manager
- 8. In OLE DB, a service provider:
Options- 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. Discuss
Correct Answer: All of the above are true of an OLE DB service provider.
- 9. ________ is considered to be one of the foundations of data access in the Microsoft world.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO Discuss
Correct Answer: OLE DB
- 10. In ODBC, a file that can be shared among database users is called a:
Options- A. system data source.
- B. file data source.
- C. user data source.
- D. SQL text file. Discuss
Correct Answer: file data source.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.