logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ The Client-Server Database See What Others Are Saying!
  • Question

  • Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?


  • Options
  • A. Each vendor desiring to be ODBC-complaint provides an ODBC driver.
  • B. Requires certain criteria to be met in order to establish an ODBC connection.
  • C. Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
  • D. All of the above.

  • Correct Answer
  • All of the above. 

    • More questions

    • 1. The benefits of a standard relational language include which of the following?

    • Options
    • A. Reduced training costs
    • B. Increased dependence on a single vendor
    • C. Applications are not needed.
    • D. All of the above.
      • Discuss
    • 2. In ODL, you specify an operation using parentheses after its name.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The JVM (Java virtual machine) interprets Java bytecode at run time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. A rule of thumb for choosing indexes for a relational database includes which of the following?

    • Options
    • A. Indexes are more useful on smaller tables.
    • B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
    • C. Do not specify a unique index for the primary key of each table.
    • D. Be careful indexing attributes that have null values.
      • Discuss
    • 5. Changing cardinalities in a database is:

    • Options
    • A. a common database design task.
    • B. a rare database design task, but does occur.
    • C. a database design task that never occurs.
    • D. is impossible to do, so a new database must be constructed and the data moved into it.
      • Discuss
    • 6. ________ is an object-oriented interface that encapsulates data-server functionality.

    • Options
    • A. ODBC
    • B. OLE DB
    • C. JPCD
    • D. ADO
      • Discuss
    • 7. The following are components of a database except ________ .

    • Options
    • A. user data
    • B. metadata
    • C. reports
    • D. indexes
      • Discuss
    • 8. Which of the following is a technique for hiding the internal implementation details of an object?

    • Options
    • A. Encapsulation
    • B. Polymorphism
    • C. Inheritance
    • D. All of the above.
      • Discuss
    • 9. The three-schema components include all, but:

    • Options
    • A. internal schema.
    • B. conceptual schema.
    • C. programming schema.
    • D. external schema.
      • Discuss
    • 10. Routers are used to transmit message packets and forward them to the correct destination over the most efficient pathway available.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.