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

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

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Client Server Database