2017 Nov IBM Official New Released C2090-913
100% Free Download! 100% Pass Guaranteed!

Informix 4GL Development

Question No: 21

The FOREACH statement is used in conjunction with the DISPLAY ARRAY statement to


  1. to load elements from a program array into a DISPLAY statement

  2. to allow the user to choose multiple elements from the screen array

  3. to open a cursor, fetch all rows into a program array, and close the cursor

  4. to scroll through all of the rows displayed on the form from the program array

Answer: C

Question No: 22

What will happen if the number of elements loaded into a program arrayexceeds the dimensions of the program array?

  1. All arrays are defined without dimensions in 4GL, so array bounds can not beexceeded.

  2. The program array will be dynamically expanded to allow the extra rows to beincluded.

  3. The assignment statement will receive a run time error that the array bounds have beenexceeded.

  4. The program array will only be loaded with thenumber of elements equal to thedimension ofthe array.

Answer: C

Question No: 23

Which characteristics are important when determining the size of a window into which a form willbe displayed?

  1. the current value of FORM LINE

  2. the current value of LEFT MARGIN

  3. the desire for a border around the window

  4. the characters used for the screen delimiters

  5. the number of lines between the braces in the form specification file

  6. the position of the right most character in the screen section of the form specification file

Answer: A,C,E,F

Question No: 24

Which cursor type can never have an ORDER BY or GROUP BY clause in its SELECTstatement?

  1. scroll cursor

  2. update cursor

  3. non-scrolling cursor

Answer: B

Question No: 25

Which parts of the DISPLAY ARRAY statement are always required?

  1. ON KEY keywords

  2. screen array name

  3. program array name

  4. END DISPLAY keywords

  5. DISPLAY ARRAY keywords

  6. BEFORE DISPLAY keywords

Answer: B,C,E

Question No: 26

Click the Exhibit button to view the exhibit. In the exhibit, how is the unit field of the fourth elementcorrectly referenced?

  1. sa_stock[23]

  2. sa_stock[4].unit

  3. sa_stock[5].unit

  4. sa_stock.unit[5]

  5. sa_stock.unit[4]

Answer: B

Question No: 27

When is the column-list optional in the INSERT statement?

  1. never

  2. if a SERIAL column is being used

  3. when the value list is also optional

  4. when values are supplied for each column in the target table

Answer: D

Question No: 28

Click the Exhibit button to view the exhibit. Given the sample code fragment in the exhibit, if thefound_one function returns a true value, which menu choices would the user see on the screen?

  1. Exit

  2. Query

  3. Update

  4. Delete

  5. Insert


Answer: A,C,D,E

Question No: 29

Which statement about INFORMIX-4GL is true?

  1. The INFORMIX-4GL C-compiled version requires a p-code runner to execute.

  2. INFORMIX-4GL for Windows is only offered in the RDS version of the product.

  3. The INFORMIX-4GL RDS version compiles faster than the INFORMIX-4GL C- compiledversion.

  4. The INFORMIX-4GL RDS version executes faster than the INFORMIX-4GL C- compiledversion.

Answer: C

Question No: 30

What is the CONSTRUCT statement used for?

  1. to include user input in SQL queries

  2. to arrange an array of program variables

  3. to pre-optimize a statement before beginning a query

  4. to build an arbitrarily complex data structure in memory

Answer: A

100% Free Download!
Download Free Demo:C2090-913 Demo PDF
100% Pass 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
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE