Client Server Database MCQs

Question 1

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

Accepted Answer

Middleware that provides access to a database.

Answer

The same thing as ODBC.

Answer

Middleware that does not provide access to a database.

Answer

The same thing as JDBC.

Question 2

Three-tier architecture includes which of the following?

Accepted Answer

A client layer and two server layers

Answer

Three server layers

Answer

Two client layers and one server layer

Answer

Three client layers

Question 3

Which of the following is true concerning the mainframe?

Accepted Answer

Mission-critical systems have tended to remain there.

Answer

It is the same thing as client/server.

Answer

Requires someone to decide which code should be on the workstation or the server.

Answer

All of the above.

Question 4

A server cannot serve on which of the following levels?

Accepted Answer

Client Layer

Answer

Business Layer

Answer

Database Layer

Answer

All of the above

Question 5

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

Accepted Answer

Presentation, Processing, and Storage

Answer

Presentation, Client, and Storage

Answer

Presentation, Client, and Processing

Answer

Presentation, Processing, and Network

Question 6

A database server is responsible for which of the following?

Accepted Answer

Database storage

Answer

Data processing logic

Answer

Data presentation logic

Answer

All of the above

Question 7

Activities of a DBMS occur in the processing component logic.

Accepted Answer

False

Answer

True

Question 8

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.

Accepted Answer

True

Answer

False

Question 9

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

Accepted Answer

True

Answer

False