logo

CuriousTab

CuriousTab

Discussion


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

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

  • Correct Answer
  • All of the above as goals of OLE DB. 


  • ODBC, OLE DB, ADO, and ASP problems


    Search Results


    • 1. ________ is an object-oriented interface that encapsulates data-server functionality.

    • Options
    • A. ODBC
    • B. OLE DB
    • C. JPCD
    • D. ADO
    • Discuss
    • 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
    • 3. ________ 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
    • 4. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

    • Options
    • A. Application failure
    • B. Instance Failure
    • C. Media Failure
    • D. Rollback failure
    • Discuss
    • 5. Which SQL phrase is not supported by Oracle?

    • Options
    • A. ON DELETE CASCADE
    • B. ON UPDATE CASCADE
    • C. CREATE SEQUENCE [SequenceName]
    • D. DROP SEQUENCE [SequenceName]
    • Discuss
    • 6. 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
    • 7. In OLE DB, which of the following represents characteristics of the recordset abstraction?

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


    Comments

    There are no comments.

Enter a new Comment