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

What is a computer file of INFORMIX-4GL instructions called?

  1. the form

  2. the module

  3. the program

  4. the function

Answer: B

Question No: 82

In which REPORT routines can the output location of a report be specified?

  1. 4GL variables

  2. REPORT function

  3. START REPORT statement

  4. FINISH REPORT statement

Answer: B,C

Question No: 83

Click the Exhibit button to view the exhibit. Given the sample code fragment in the exhibit, whichmenu option would the user never see on the screen?

  1. Command quot;quot;

  2. Command quot;Queryquot;

  3. Command key (quot;Equot;, quot;Xquot;)

  4. Command key (CONTROL-B)

Answer: D

Question No: 84

What is the arr_curr() library function used to determine?

  1. the maximum size of the program array

  2. the number of elements in the screen array

  3. the number of elements in the program array

  4. the number of rows visible in the screen array

  5. the current line of the cursor in the screen array

  6. the current line of the cursor in the program array

Answer: F

Question No: 85

Assume table B has foreign keys referencing the primary keys in tableA.How can data integritybe maintained at the application level during deletes from table A?

  1. by using a FOR UPDATE cursor to lock the row being deleted from table A

  2. by checking the SQLCA structure after the DELETE statement has been issued

  3. by checking table B for foreign key values that reference primary keys being deleted in table A

  4. by checking table A for foreign key values that reference primary keys being deleted in table B

Answer: C

Question No: 86

What is the scope of a transaction?

  1. the program

  2. the module where the transaction was started

  3. the function where the transaction was started

Answer: A

Question No: 87

What is a report driver?

  1. An OS program which implements the report facility.

  2. A function which formats the data output from a report.

  3. A procedure which defines all program variables used in the report.

  4. A routine which retrieves data and sends it to the report definition function.

Answer: D

Question No: 88

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

  1. supply an quot;index of primary keysquot; to the stock_all_curs

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

  3. check if any new rows have been inserted into the table since the stock_all_curs was lastopened

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

Answer: A

Question No: 89

Click the Exhibit button to view the exhibit. Given the code in the exhibit, which could be theoutput?

  1. SMITH JIM A JONES MARY PUBLIC JOHN Q.

  2. SMITHJIM

  3. JONESMARY PUBLICJOHN Q.

  4. SMITH JIM

  5. JONES MARY PUBLIC JOHN Q.

  6. SMITH JIM

  7. JONES MARY PUBLIC JOHN Q.

Answer: A

Question No: 90

Which statements implement explicit transactions?

  1. BEGIN WORK

  2. COMMIT WORK

  3. ROLLBACK WORK

  4. END TRANSACTION

  5. EXIT TRANSACTION

  6. START TRANSACTION

Answer: A,B,C

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