QUESTION:137 Why might you check SQLCA.SQLERRD after an UPDATE statement? A. Because SQLCA.SQLCODE is not set during an UPDATE statement. B. Because UPDATE statements can affect multiple rows in a table. C. Because it must be checked that NOT all rows are updated with the UPDATE statement. D. Because if an error occurs in an unlogged database, the transaction will be rolled back. Answer:B QUESTION:138 Which statements are true about the WHENEVER ERROR statement options? A. WHENEVER ERROR STOP terminates the program immediately on receipt of an error. B. WHENEVER ERROR CONTINUE continues execution on receipt of an error and data NOTFOUND condition. C. WHENEVER ERROR STOP terminates the program immediately, for all error and data NOTFOUND conditions. D. WHENEVER ERROR CALL causes execution of the 4GL run-time library error-handler upon receipt of an error condition. Answer:A,B QUESTION:139 Why will preparing UPDATE and DELETE statements increase their execution speed?