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