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

Informix 4GL Development

Question No: 31

Which statement is true about the CLEAR SCREEN statement?

  1. It will clear all windows from a user#39;s screen.

  2. It will close windows and release associated memory.

  3. It will only clear the current window from a user#39;s screen.

  4. It will clear associated memory for the form as well as the screen.

Answer: A

Question No: 32

Which statement is true about the CURRENT WINDOW statement?

  1. CURRENT WINDOW IS SCREEN is an invalid statement.

  2. It only allows one window to be current at a time.

  3. It only allows one window to be visible on the screen at a time.

  4. It will close windows and clear associated memory of other windows.

Answer: B

Question No: 33

At run-time, conditions may occur that produce warnings, but not errors.How can you easily look for these warnings?

  1. Check STATUS for gt;0.

  2. Check SQLCA.SQLAWARN for specific warning numbers.

  3. Check SQLCODE, if set to gt;0, examine contents of each SQLCA.SQLAWARN component.

  4. Check SQLCA.SQLAWARN[1], if set to quot;Wquot;, examine contents of each SQLCA.SQLAWARNcomponent.

Answer: D

Question No: 34

Which clauses must be included in an INPUT statement?

  1. TO

  2. FROM

  3. INPUT


  5. screen_variable

  6. program_variable

Answer: C,F

Question No: 35

What is the INPUT ARRAY statement used for?

  1. to display a form which contains an array

  2. to dynamically dimension the program array

  3. to load a program array from a database table

  4. to enter multiple rows from a form into a program array

Answer: D

Question No: 36

Which statements are true about SQLCA?

  1. SQLCA is implicitly defined.

  2. SQLCA.SQLCODE and STATUS will always contain the same values.

  3. One copy of the SQLCA structure is defined for each SQL statement.

  4. SQLCA is an abbreviation for Structured Query Language Communications Access.

Answer: A,D

Question No: 37

Which screen interaction statement is terminal screen dependent as opposed to CURRENTWINDOW dependent?

  1. ERROR




Answer: A

Question No: 38

What is the effect of the WITHOUT DEFAULTS clause of an INPUT statement?

  1. It initializes the program variables to NULL.

  2. It prevents user input of DEFAULT values in the form.

  3. It prevents the program variables from being initialized to NULL.

  4. It initializes the program variables to their table-defined defaults.

Answer: C

Question No: 39

What can the arr_count() library function be used to determine?

  1. the current position in the screen array

  2. the current position in the program array

  3. the number of elements in the screen array

  4. the number of elements in the program array

Answer: D

Question No: 40

After which event is a cursor declared WITH HOLD closed?

  1. After the transaction ends.

  2. After another cursor is opened.

  3. After the CLOSE statement is executed.

  4. After the function currently executing is exited.

  5. After the last row from the active set is fetched.

Answer: C

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