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

Result in thicker client and thinner database server.
Network traffic increases.
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.

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

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP