Discussion
Home ‣ Database ‣ ODBC, OLE DB, ADO, and ASP Comments
- Question
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
Options- A. ODBC
- B. ASP
- C. JPCD
- D. ADO
- Correct Answer
- ADO
- 1. ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Options- A. ASP
- B. XML
- C. ODBC
- D. ADO Discuss
- 2. When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
Options- A. Data source
- B. Driver
- C. Driver manager
- D. DBMS Discuss
- 3. The ODBC Level 2 API contains which 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. All of the above are contained in the OBDC Level 2 API Discuss
- 4. 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
- 5. 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
- 6. In OLE DB, actions that an object can perform are called:
Options- A. properties.
- B. collections.
- C. methods.
- D. abstractions. Discuss
- 7. A JSP is transformed into a(n):
Options- A. Java applet.
- B. Java servlet.
- C. Either 1 or 2 above.
- D. Neither 1 nor 2 above. Discuss
- 8. Which JDBC driver Types are for use over communications networks?
Options- A. Type 3 only
- B. Type 4 only
- C. Both Type 3 and Type 4
- D. Neither Type 3 nor Type 4 Discuss
- 9. How many JDBC driver types does Sun define?
Options- A. One
- B. Two
- C. Three
- D. Four Discuss
- 10. What MySQL property is used to create a surrogate key in MySQL?
Options- A. UNIQUE
- B. SEQUENCE
- C. AUTO_INCREMENT
- D. None of the above -- Surrogate keys are not implemented in MySQL. Discuss
ODBC, OLE DB, ADO, and ASP problems
Search Results
Correct Answer: ADO
Correct Answer: Driver
Correct Answer: All of the above are contained in the OBDC Level 2 API
Correct Answer: system data source.
Correct Answer: INSERT, UPDATE, DELETE only
Correct Answer: methods.
Correct Answer: Java servlet.
Correct Answer: Both Type 3 and Type 4
Correct Answer: Four
Correct Answer: AUTO_INCREMENT
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.