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

Result in thicker client and thinner database server.
Network traffic increases.
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 a true statement concerning the open database connectivity standard (ODBC)?

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.
All of these

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP