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

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

ANSWER DOWNLOAD EXAMIANS APP

Client Server Database
Which of the following statements is true about symmetric multiprocessing?

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

ANSWER DOWNLOAD EXAMIANS APP

Client Server Database
Which of the following is true concerning QBE?

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

ANSWER DOWNLOAD EXAMIANS APP

Client Server Database
Stored procedures have which of the following advantages?

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

ANSWER DOWNLOAD EXAMIANS APP