IBM C2090-913 - Informix 4GL Development Exam

Page:    1 / 30   
Total 149 questions

For a non-ANSI database, if an UPDATE statement executes successfully,but modifies no rows in the database, what will SQLCA.SQLCODE be set to?

  • A. 0
  • B. 1
  • C. <0
  • D. the number of rows in the target table


Answer : A

An end user wants to see how values x and y are being set in function1 and function2, and alsoneeds to know the value of z before function3 is called. Given the following:
1.MAIN
2.
3.DEFINE x, y, z SMALLINT
4.LET z = 0
5.CALL function1() RETURNING x
6.CALL function2() RETURNING y
7.IF ( y > 0 ) THEN
8.LET z = x / y
9.CALL function3 (z) RETURNING z
10.END IF
11........
12.END MAIN
Using the Informix 4GL Debugger, which sequence of steps accomplishes this?

  • A. set a break point for line 6, execute a call function2, execute a step/step
  • B. set a break point for line 5, execute a call function1, execute a call function2, execute print z online 10
  • C. set a break point for line 5, execute a step into on lines 5 and 6; execute print z on line 9 priorto executing a step/step into/continue
  • D. set a break point for line 5, execute a step, print x, execute a step, print y, execute print z online 9 prior to executing a step/step into/continue


Answer : C

Which statement uses correct syntax for the INPUT statement?

  • A. INPUT program_variable FROM screen_variable
  • B. INPUT FROM program_variable TO screen_variable
  • C. INPUT TO program_variable FROM screen_variable
  • D. INPUT ATTRIBUTE BY NAME TO program_variable FROM screen_variable


Answer : A

For a non MODE ANSI database, what is the default behavior for handling arun-time error?

  • A. The program continues, logging the error to the error log.
  • B. The program displays an error message and the program is terminated.
  • C. The program executes the default handler provided in the run-time libraries.
  • D. The program is interrupted, issuing a prompt to the user for further processing direction.


Answer : B

Click the Exhibit button to view the exhibit Given the exhibit, which is the correct syntax forexecuting the INSERT statement?

  • A. EXECUTE ex_stmt1
  • B. EXECUTE prep_var1
  • C. EXECUTE ex_stmt1 USING stock.*
  • D. EXECUTE prep_var1 USING stock.*
  • E. EXECUTE ex_stmt1 USING stock_rec.*
  • F. EXECUTE prep_var1 USING stock_rec.*


Answer : E

Page:    1 / 30   
Total 149 questions