Discussion
Home ‣ Database ‣ ODBC, OLE DB, ADO, and ASP Comments
- Question
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.
- Correct Answer
- file data source.
- 1. ________ 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
- 2. 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
- 3. 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
- 4. In OLE DB, which of the following represents characteristics of the recordset abstraction?
Options- A. Properties
- B. Collections
- C. Methods
- D. Abstractions Discuss
- 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
- 6. ODBC core SQL grammar contains which of the following?:
Options- A. INSERT, UPDATE, DELETE only
- B. Stored procedures only
- C. Full SELECT (includes subqueries) only
- D. Both 1 and 3 above are contained in the ODBC core SQL. Discuss
- 7. The ODBC core API consists of which of the following functions?
Options- A. Commit or rollback transactions only
- B. Connect to data sources with driver-specific information only
- C. Connect to data sources only
- D. Both 1 and 3 above are in the OBDC core API. Discuss
- 8. The ODBC Level 1 API contains which of the following functions?
Options- 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. Discuss
- 9. ODBC minimum SQL grammar contains which of the following?
Options- A. INSERT, UPDATE, DELETE only
- B. Stored Procedures only
- C. Literals for date, time and timestamp only
- D. CREATE VIEW, DROP VIEW only Discuss
- 10. In ODBC, a data source that is local to a single computer is called a:
Options- A. system data source.
- B. file data source.
- C. user data source.
- D. SQL text file. Discuss
ODBC, OLE DB, ADO, and ASP problems
Search Results
Correct Answer: OLE DB
Correct Answer: All of the above are true of an OLE DB service provider.
Correct Answer: Driver manager
Correct Answer: Properties
Correct Answer: data source.
Correct Answer: Both 1 and 3 above are contained in the ODBC core SQL.
Correct Answer: Both 1 and 3 above are in the OBDC core API.
Correct Answer: Connect to data sources with driver-specific information only
Correct Answer: INSERT, UPDATE, DELETE only
Correct Answer: system data source.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.