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: 71

Click the Exhibit button to view the exhibit. Given the clauses in the exhibit, which clause will beexecuted immediately after the user presses the ACCEPT KEY while in the code field?

  1. AFTER ROW

  2. BEFORE ROW

  3. AFTER INSERT

  4. AFTER FIELD code

Answer: D

Question No: 72

Which cursor type can use the FETCH PREVIOUS syntax?

  1. scroll cursor

  2. update cursor

  3. non-scrolling cursor

  4. a mobile cursor available only in D4GL

Answer: A

Question No: 73

Which statement is true about the SERIAL data type?

  1. A table can have multiple SERIAL columns.

  2. SERIAL values within a table MUST be unique.

  3. SERIAL values are stored in the database as integers.

  4. Once deleted, SERIAL values are automatically reused.

Answer: C

Question No: 74

Click the Exhibit button to view the exhibit. After the code in the exhibit is executed, what is thevalue of quot;totalquot;?

  1. 1

  2. 11

  3. 10

D. 100

Answer: B

Question No: 75

What is required in a form to implement multiple-line editing features for acharacter field?

  1. two fields of the same length in the SCREEN section

  2. an OPTIONS WORD WRAP line in the INSTRUCTIONS section

  3. a SCREEN RECORD for the field in the INSTRUCTIONS section

  4. at least two fields in the SCREEN section with the same field tag

  5. the WORDWRAP attribute included for the field in the ATTRIBUTES section

Answer: D,E

Question No: 76

Which qualifiers can be used when formatting report output?

  1. USING

  2. SPACES

  3. STRING

  4. NEWLINE

  5. PICTURE

  6. CLIPPED

Answer: A,B,F

Question No: 77

Which functions can be used within a conditional expression?

  1. FUNCTION funca() DEFINE ret_code integer LET ret_code = 10 END FUNCTION

  2. FUNCTION funca() DEFINE ret_code integer LET ret_code = 10 RETURN ret_code ENDFUNCTION

  3. FUNCTION funca() DEFINE ret_code integer LET ret_code =10 LET ret_code2 = 20 RETURNret_code, ret_code2 END FUNCTION

  4. FUNCTION funca(param) DEFINE ret_code, param integer LET ret_code = param * 10RETURN ret_code END FUNCTION

Answer: B,D

Question No: 78

Which statements explain the purpose of the ATTRIBUTES section of aform?

  1. It lets you define the size of the screen form.

  2. It links a field tag on the screen with a column in the table.

  3. It allows you to add specific commands that will determine the behavior and appearance of thefields on the screen.

  4. It lets you determine the order in which the cursor will navigate through the fields of the screenform.

Answer: B,C

Question No: 79

Which type of cursor is used with the WHERE CURRENT OF statement?

  1. scroll cursor

  2. update cursor

  3. non-scrolling cursor

Answer: B

Question No: 80

Which structure contains information about the most recently executed SQL statement?

  1. SCLDA

  2. SQLCA

  3. SQLERRD

  4. SQLCODE

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-913 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-913 Dumps

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