logo

CuriousTab

CuriousTab

Discussion


Home Database ODBC, OLE DB, ADO, and ASP Comments

  • Question
  • 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.

  • Correct Answer
  • Both 1 and 3 above are contained in the ODBC core SQL. 


  • ODBC, OLE DB, ADO, and ASP problems


    Search Results


    • 1. 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
    • 2. ________ 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
    • 3. 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
    • 4. 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
    • 5. In OLE DB, which of the following represents characteristics of the recordset abstraction?

    • Options
    • A. Properties
    • B. Collections
    • C. Methods
    • D. Abstractions
    • Discuss
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment