Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-913
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-913.html

Informix 4GL Development

Question No: 1

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?

  1. 0

  2. 1

  3. lt;0

  4. the number of rows in the target table

Answer: A

Question No: 2

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.

  1. DEFINE x, y, z SMALLINT

  2. LET z = 0

  3. CALL function1() RETURNING x 6.CALL function2() RETURNING y 7.IF ( y gt; 0 ) THEN

  1. LET z = x / y

  2. CALL function3 (z) RETURNING z 10.END IF

11……..

  1. END MAIN

    Using the Informix 4GL Debugger, which sequence of steps accomplishes this?

    1. set a break point for line 6, execute a call function2, execute a step/step

    2. set a break point for line 5, execute a call function1, execute a call function2, execute print z online 10

    3. 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

    4. 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 No: 3

Which statement uses correct syntax for the INPUT statement?

  1. INPUT program_variable FROM screen_variable

  2. INPUT FROM program_variable TO screen_variable

  3. INPUT TO program_variable FROM screen_variable

  4. INPUT ATTRIBUTE BY NAME TO program_variable FROM screen_variable

Answer: A

Question No: 4

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

  1. The program continues, logging the error to the error log.

  2. The program displays an error message and the program is terminated.

  3. The program executes the default handler provided in the run-time libraries.

  4. The program is interrupted, issuing a prompt to the user for further processing direction.

Answer: B

Question No: 5

Click the Exhibit button to view the exhibit Given the exhibit, which is the correct syntax

forexecuting the INSERT statement?

  1. EXECUTE ex_stmt1

  2. EXECUTE prep_var1

  3. EXECUTE ex_stmt1 USING stock.*

  4. EXECUTE prep_var1 USING stock.*

  5. EXECUTE ex_stmt1 USING stock_rec.*

  6. EXECUTE prep_var1 USING stock_rec.*

Answer: E

Question No: 6

Which statements are true about the PREPARE statement?

  1. You can use question mark syntax with the PREPARE statement.

  2. A transaction is implicitly started when the statement is executed.

  3. The PREPARE statement will preprocess the SQL statement before it is run.

  4. The PREPARE statement is mandatory when using the SELECT and INSERT clauses.

  5. It will be prepared implicitly when the cursor is opened if the SQL statement has not beenprepared explicitly.

Answer: A,C,E

Question No: 7

Which are required for a C function call?

  1. the name of the C function

  2. the type of function call

  3. a call to the start_fgl() function

  4. any arguments passed to the C function

  5. any return variables from the C function

Answer: A,D,E

Question No: 8

Click the Exhibit button to view the exhibit. Given the exhibit, what is the stock_all_curs beingused to do?

  1. re-populate the temporary table created by the stock_curs cursor

  2. lock the current row of data in the database table toprevent the data from becomingstale

  3. check if any new rows have been inserted into the table since the stock_curs cursorwas lasopened

  4. fetch the complete row of data from the database for the primary key supplied by the stock_curs cursor

Answer: D

Question No: 9

Which type of cursor would be most effective if a row needs to be locked while it is examined todetermine if it should be deleted?

  1. scroll cursor

  2. update cursor

  3. non-scrolling cursor

Answer: B

Question No: 10

Which code segment will show field-specific help at the user request during an INPUT statement?

  1. ON KEY (F1) CASE WHEN infield(a) CALL showhelp(1) WHEN infield(b) CALL showhelp(2) …

    END CASE

  2. INPUT BY NAME r_record.* HELP var BEFORE FIELD a LET var = 1 BEFORE FIELD b LET

    var = 2 … END INPUT

  3. ON KEY (F1) CASE WHEN infield(a) showhelp(1) WHEN infield(b) showhelp(2) … END CASE

  4. INPUT BY NAME r_record.* BEFORE FIELD a CALL showhelp(1) BEFORE FIELD b CALL

showhelp(2) … END INPUT

Answer: A

100% Ensurepass Free Download!
Download Free Demo:C2090-913 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-913 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE