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

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

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
Which of the following statements is true about symmetric multiprocessing?

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

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Client Server Database