logo

CuriousTab

CuriousTab

Discussion


Home Database The Client-Server Database Comments

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


  • The Client-Server Database problems


    Search Results


    • 1. A characteristic of a file server is which of the following?

    • Options
    • A. Manages file operations and is shared on a network.
    • B. Manages file operations and is limited to one PC.
    • C. Acts as a fat client and is shared on a network.
    • D. Acts as a fat client and is limited to one PC.
    • Discuss
    • 2. Client/server security includes which of the following?

    • Options
    • A. Physical security
    • B. Change control security
    • C. Measures taken to secure all systems
    • D. All of the above.
    • Discuss
    • 3. A server cannot serve on which of the following levels?

    • Options
    • A. Client Layer
    • B. Business Layer
    • C. Database Layer
    • D. All of the above.
    • Discuss
    • 4. The three different application logic components are which of the following?

    • Options
    • A. Presentation, Client, and Storage
    • B. Presentation, Client, and Processing
    • C. Presentation, Processing, and Storage
    • D. Presentation, Processing, and Network
    • Discuss
    • 5. Which of the following statements is true concerning JDBC?

    • Options
    • A. It is language independent.
    • B. It is similar in concept to ODBC.
    • C. It is useful for all object-oriented languages.
    • D. It consists of three main layers.
    • Discuss
    • 6. An application program interface (API) is which of the following?

    • Options
    • A. The same thing as ODBC.
    • B. Middleware that does not provide access to a database.
    • C. Middleware that provides access to a database.
    • D. The same thing as JDBC.
    • Discuss
    • 7. Stored procedures have which of the following advantages?

    • Options
    • A. It takes a longer time to write them as compared to writing Visual Basic.
    • B. Network traffic increases
    • C. Data integrity improves as multiple applications access the same stored procedure.
    • D. Result in thicker client and thinner database server.
    • Discuss
    • 8. A database server is responsible for which of the following?

    • Options
    • A. Database storage
    • B. Data processing logic
    • C. Data presentation logic
    • D. All of the above.
    • Discuss
    • 9. Three-tier architecture includes which of the following?

    • Options
    • A. Three server layers
    • B. A client layer and two server layers
    • C. Two client layers and one server layer
    • D. Three client layers
    • Discuss
    • 10. Which of the following is true concerning the mainframe?

    • Options
    • A. It is the same thing as client/server.
    • B. Requires someone to decide which code should be on the workstation or the server.
    • C. Mission-critical systems have tended to remain there.
    • D. All of the above.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment