logo

CuriousTab

CuriousTab

Discussion


Home Database ODBC, OLE DB, ADO, and ASP See What Others Are Saying!
  • Question
  • 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

  • Correct Answer
  • Driver 


  • More questions

    • 1. A data warehouse is which of the following?

    • Options
    • A. Can be updated by end users.
    • B. Contains numerous naming conventions and formats.
    • C. Organized around important subject areas.
    • D. Contains only current data.
    • Discuss
    • 2. Information repositories are replacing data dictionaries in many organizations.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. Which of the following is true concerning QBE?

    • Options
    • A. An official standard has been defined for QBE.
    • B. QBE cannot be used for client/server systems.
    • C. QBE does not give the programmer a visual programming environment.
    • D. Complete applications can be written using QBE.
    • Discuss
    • 4. For every relationship, how many possible sets of minimum cardinalities are there?

    • Options
    • A. Two
    • B. Three
    • C. Four
    • D. Six
    • 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 entity is something that can be identified in the user's work environment; something that the users want to track.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. 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
    • 8. A reason for using an SQL view to hide columns is:

    • Options
    • A. to simplify a result only.
    • B. to prevent the display of sensitive data only.
    • C. to accomplish both of the above.
    • D. None of the above are reasons for using an SQL view.
    • Discuss
    • 9. Eliminating modification anomalies is a(n) ________ of normalization.

    • Options
    • A. advantage
    • B. disadvantage
    • C. either an advantage or disadvantage
    • D. neither an advantage nor disadvantage
    • Discuss
    • 10. What mode of authentication does SQL Server NOT provide?

    • Options
    • A. Windows-only security
    • B. Both SQL Server and Windows-only security
    • C. Mixed security
    • D. SQL Server only security
    • Discuss


    Comments

    There are no comments.

Enter a new Comment