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

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

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP

Client Server Database
A characteristic of a file server is which of the following?

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

ANSWER DOWNLOAD EXAMIANS APP