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

Informix 4GL Development

Question No: 61

Which OPEN FORM statements are syntactically correct?

  1. OPEN FORM formname FROM quot;formfilequot;

  2. OPEN FORM formname FROM formvariable

  3. OPEN FORM quot;formnamequot; FROM formfile.frm

  4. OPEN FORM formname IN WINDOW winname WITH FORM quot;formfilequot;

  5. OPEN FORM formname FROM quot;formfile.frmquot;

Answer: A,B

Question No: 62

SQL statements being prepared in conjunction with a CONSTRUCT statement should beprepared

  1. just before the SQL statement is to be executed or opened

  2. in an initialization function at the top of each 4GL module

  3. at the top of each function containing the EXECUTE or OPEN statement

  4. in an initialization function in the module containing the MAIN function

Answer: A

Question No: 63

After a user-interrupt sets the int_flag to TRUE, how can it be reset toFALSE?

  1. by INFORMIX-4GL after 1 second has elapsed

  2. by executing the DEFER INTERRUPT statement

  3. only if the application code resets it to FALSE

  4. by INFORMIX-4GL after the IF int_flag statement is executed

Answer: C

Question No: 64

Which cursor type always places a lock on the current row fetched?

  1. scroll cursor

  2. update cursor

  3. non-scrolling cursor

Answer: B

Question No: 65

Which cursor is most effective when retrieving data for a user that wants areport to generate a customer listing sorted by city and last name?

  1. update cursor

  2. scroll cursor

  3. non-scrolling cursor

Answer: C

Question No: 66

Which are components of the SQLCA record?






Answer: B,D,E

Question No: 67

Which parameters can be passed to a function?

  1. constants

  2. concatenators

  3. date variables

  4. array variables

  5. integer variables

Answer: A,C,E

Question No: 68

Click the Exhibit button to view the exhibit. Given the code in the exhibit, whichstatement iscorrect?

  1. The WHENEVER ERROR CONTINUE is active while in function A.

  2. The WHENEVER ERROR CONTINUE is active when function B is called.

  3. The WHENEVER ERROR STOP is active for MAIN, function A and function B.

  4. The WHENEVER ERROR STOP is active throughout as it was declared in the MAIN function.

Answer: C

Question No: 69

What is a disadvantage of using a SCROLL cursor?

  1. GROUP BY clauses are not allowed.

  2. Temporary tables are always created and could be quite large.

  3. Rows fetched must be retrieved from the database table each time.

  4. Temporary tables may have to be created and could be quite large.

Answer: B

Question No: 70

Which ATTRIBUTE clauses are valid?

  1. ERROR quot;textquot; ATTRIBUTE (SILENT)

  2. MESSAGE quot;textquot; ATTRIBUTE (REVERSE)

  3. DISPLAY quot;textquot; AT 2, 2 ATTRIBUTE (BORDER)


Answer: B,D

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
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE