CLIENT SERVER DATABASE QUIZ

Three-tier architecture includes which of the following?

Three client layers

Two client layers and one server layer

A client layer and two server layers

Three server layers

TRUE ANSWER : ?
YOUR ANSWER : ?

Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

All of these

Requires certain criteria to be met in order to establish an ODBC connection.

Each vendor desiring to be ODBC-complaint provides an ODBC driver.

Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is true concerning QBE?

An official standard has been defined for QB

Complete applications can be written using QB

QBE cannot be used for client/server systems.

QBE does not give the programmer a visual programming environment.

TRUE ANSWER : ?
YOUR ANSWER : ?

The Windows operating system and Windows applications are event driven.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following items are not necessary for client/server?

Determine network bandwidth capabilities.

Assure that tools will connect with middleware.

Understand the requirements.

Include the use of a file server.

TRUE ANSWER : ?
YOUR ANSWER : ?

Query-by-Example (QBE) is the most widely available direct-manipulation database query language.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

New modules can be built to support specific business needs

Performance improves for compiled SQL statements

All of these

Results in a thinner client and database server

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?