Informix-4GL-Development-(000-913).pdf - IBM 000-913 Informix 4GL Development http\/killexams.com\/exam-detail\/000-913 QUESTION 137 Why might you check

Informix-4GL-Development-(000-913).pdf - IBM 000-913...

This preview shows page 1 - 3 out of 8 pages.

000-913 IBM Informix 4GL Development
Image of page 1
QUESTION: 137 Why might you check SQLCA.SQLERRD[3] 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?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '16
  • Mohammad Alizadeh
  • Control flow, Computer program

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture