Q.1

With an asynchronous system, the requesting system waits for a response in real time.

  • True
  • False
Q.2

The first client/server architectures developed were file servers.

  • True
  • False
Q.3

Activities of a DBMS occur in the processing component logic.

  • True
  • False
Q.4

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

  • True
  • False
Q.5

A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.

  • True
  • False
Q.6

Centralized systems are more susceptible to security threats than client/server architectures.

  • True
  • False
Q.7

Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.

  • True
  • False
Q.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.

  • True
  • False
Q.9

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

  • True
  • False
Q.10

Stored procedures have which of the following advantages?

  • It takes a longer time to write them as compared to writing Visual Basic.
  • Network traffic increases
  • Data integrity improves as multiple applications access the same stored procedure.
  • Result in thicker client and thinner database server.
Q.11

Three-tier architecture includes which of the following?

  • Three server layers
  • A client layer and two server layers
  • Two client layers and one server layer
  • Three client layers
Q.12

Which of the following statements is true about symmetric multiprocessing?

  • A single copy of the operating system resides in each processor.
  • Useful for situations where data must remain in memory to process.
  • Bottlenecks increase with uniprocessor systems because tasks are not shared.
  • The problems of memory contention are unlikely.
Q.13

Client/server environments use a local area network (LAN) to support a network of personal computers, each with its own storage, that are also able to share common devices and software attached to the LAN.

  • True
  • False
Q.14

Data processing logic includes such activities as data validation and identification of processing errors.

  • True
  • False
Q.15

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

  • True
  • False
Q.16

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

  • Each vendor desiring to be ODBC-complaint provides an ODBC driver.
  • Requires certain criteria to be met in order to establish an ODBC connection.
  • Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
  • All of the above.
Q.17

Which of the following is true concerning the mainframe?

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

A server cannot serve on which of the following levels?

  • Client Layer
  • Business Layer
  • Database Layer
  • All of the above.
Q.19

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

  • Assure that tools will connect with middleware.
  • Understand the requirements.
  • Determine network bandwidth capabilities.
  • Include the use of a file server.
Q.20

The database server is responsible for database storage, access, and processing.

  • True
  • False
0 h : 0 m : 1 s