logo

CuriousTab

CuriousTab

The Client-Server Database problems


  • 1. A benefit of the three-tier architecture is which of the following?

  • Options
  • A. New modules can be built to support specific business needs
  • B. Performance improves for compiled SQL statements
  • C. Results in a thinner client and database server
  • D. All of the above.
  • Discuss
  • 2. 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
  • 3. 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
  • 4. 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
  • 5. 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
  • 6. 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
  • 7. 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.
  • Discuss
  • 8. 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
  • 9. 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
  • 10. 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

First 2