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. TRUE ANSWER : ? YOUR ANSWER : ?
The Windows operating system and Windows applications are event driven. False True TRUE ANSWER : ? YOUR ANSWER : ?
Data processing logic includes such activities as data validation and identification of processing errors. False True TRUE ANSWER : ? YOUR ANSWER : ?
Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application. True False TRUE ANSWER : ? YOUR ANSWER : ?
The database server is responsible for database storage, access, and processing. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following statements is true concerning JDBC? It is useful for all object-oriented languages. It is similar in concept to ODB It is language independent. It consists of three main layers. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)? Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed. All of these Requires certain criteria to be met in order to establish an ODBC connection. Each vendor desiring to be ODBC-complaint provides an ODBC driver. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is true concerning the mainframe? It is the same thing as client/server. Requires someone to decide which code should be on the workstation or the server. All of these Mission-critical systems have tended to remain there. TRUE ANSWER : ? YOUR ANSWER : ?
Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory. False True TRUE ANSWER : ? YOUR ANSWER : ?