C2090-913 Exam - Free IBM Questions and Answers

Question #1 (Topic: )

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

Question #2 (Topic: )

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

Question #3 (Topic: )

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

Question #4 (Topic: )

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

Question #5 (Topic: )

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

IBM C2090-913 - Informix 4GL Development Exam