Client Server Database Test(1st)

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

1 Mark(s)

Results in a thinner client and database server
All of the above.
Performance improves for compiled SQL statements
New modules can be built to support specific business needs

Which of the following is true concerning the mainframe?

1 Mark(s)

All of the above.
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.

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

1 Mark(s)

False
True

Stored procedures have which of the following advantages?

1 Mark(s)

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

Which of the following statements is true concerning JDBC?

1 Mark(s)

It is language independent.
It is similar in concept to ODBC.
It consists of three main layers.
It is useful for all object-oriented languages.

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.

1 Mark(s)

False
True

ODBC requires the specific driver.

1 Mark(s)

True
False

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

1 Mark(s)

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

The Windows operating system and Windows applications are event driven.

1 Mark(s)

False
True

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

1 Mark(s)

False
True

A server cannot serve on which of the following levels?

1 Mark(s)

Client Layer
Database Layer
All of the above
Business Layer

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

1 Mark(s)

Middleware that does not provide access to a database.
The same thing as ODBC.
Middleware that provides access to a database.
The same thing as JDBC.

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

1 Mark(s)

False
True

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

1 Mark(s)

True
False

Which of the following is true concerning QBE?

1 Mark(s)

Complete applications can be written using QBE.
QBE does not give the programmer a visual programming environment.
QBE cannot be used for client/server systems.
An official standard has been defined for QBE.

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 Mark(s)

False
True

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

1 Mark(s)

False
True

Which of the following statements is true about symmetric multiprocessing?

1 Mark(s)

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

Activities of a DBMS occur in the processing component logic.

1 Mark(s)

True
False

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

1 Mark(s)

All of the above.
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.
Each vendor desiring to be ODBC-complaint provides an ODBC driver.

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

1 Mark(s)

True
False

Three-tier architecture includes which of the following?

1 Mark(s)

A client layer and two server layers
Three server layers
Two client layers and one server layer
Three client layers

A characteristic of a file server is which of the following?

1 Mark(s)

Acts as a fat client and is shared on a network.
Manages file operations and is shared on a network.
Manages file operations and is limited to one PC.
Acts as a fat client and is limited to one PC.

Client/server security includes which of the following?

1 Mark(s)

Change control security
Physical security
All of the above
Measures taken to secure all systems

The first client/server architectures developed were file servers.

1 Mark(s)

True
False

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

1 Mark(s)

False
True

A database server is responsible for which of the following?

1 Mark(s)

All of the above
Data processing logic
Data presentation logic
Database storage

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

1 Mark(s)

Presentation, Processing, and Network
Presentation, Client, and Storage
Presentation, Processing, and Storage
Presentation, Client, and Processing

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

1 Mark(s)

False
True

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

1 Mark(s)

False
True

Client Server Database Test(1st) : Question 1 of 30