Commerce

Client Server Database MCQs

Practice Client Server Database MCQs for competitive exams.

Client Server Database MCQs

Practice questions from this topic.

Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.

  1. A. True
  2. B. False
Report Error

The presentation logic component is responsible for formatting and presenting data on the user's screen or other output device, and for managing user input from a keyboard or other input device.

  1. A. True
  2. B. False
Report Error

Activities of a DBMS occur in the processing component logic.

  1. A. True
  2. B. False
Report Error

A database server is responsible for which of the following?

  1. A. Database storage
  2. B. Data processing logic
  3. C. Data presentation logic
  4. D. All of the above
Report Error

The three different application logic components are which of the following?

  1. A. Presentation, Client, and Storage
  2. B. Presentation, Client, and Processing
  3. C. Presentation, Processing, and Storage
  4. D. Presentation, Processing, and Network
Report Error

A server cannot serve on which of the following levels?

  1. A. Client Layer
  2. B. Business Layer
  3. C. Database Layer
  4. D. All of the above
Report Error

Which of the following is true concerning the mainframe?

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

Three-tier architecture includes which of the following?

  1. A. Three server layers
  2. B. A client layer and two server layers
  3. C. Two client layers and one server layer
  4. D. Three client layers
Report Error

An application program interface (API) is which of the following?

  1. A. The same thing as ODBC.
  2. B. Middleware that does not provide access to a database.
  3. C. Middleware that provides access to a database.
  4. D. The same thing as JDBC.
Report Error

Client/server security includes which of the following?

  1. A. Physical security
  2. B. Change control security
  3. C. Measures taken to secure all systems
  4. D. All of the above
Report Error

Which of the following is true concerning QBE?

  1. A. An official standard has been defined for QBE.
  2. B. QBE cannot be used for client/server systems.
  3. C. QBE does not give the programmer a visual programming environment.
  4. D. Complete applications can be written using QBE.
Report Error

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

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