EnsurePass
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: 51

How could two cursors be used to implement a solution for the large temporary table and staledata problems of a SCROLL cursor?

  1. The FOR UPDATE CURSOR would fetch the rows initially from the database table, locking allof the rows, while a second SCROLL CURSOR would be used to fetch the data from thetemporary table when needed.

  2. The SCROLL CURSOR would fetch the rows initially from the database table while a secondFOR UPDATE CURSOR would be used to lock the rows as they are fetched a second timepreventing the data from becoming stale.

  3. The SCROLL CURSOR would fetch only the primary keys of the data row from the temporarytable created by the SCROLL CURSOR while a second non-scrollingCURSOR

    would use theprimary key of the current row to fetch all other columns of the data row from the databasetable.

  4. The non-scrolling CURSOR would fetch only the primary keys of the data row from thedatabase table while a second SCROLL CURSOR would use the primary key of thecurrentrow to fetch all other columns of the data row from the temporary table created by theSCROLL CURSOR.

Answer: C

Question No: 52

Which statements about INFORMIX-4GL are true?

  1. Its programs contain modules.

  2. Its modules contain functions.

  3. The GLOBALS function is required.

  4. A function contains INFORMIX-4GL instructions.

  5. The GLOBALS function contains screen record definitions.

  6. Its MAIN function must be the first function in a module.

  7. The REPORT function contains special INFORMIX-4GL instructions.

Answer: A,B,D,G

Question No: 53

How is the int_flag set to true?

  1. The user presses the quit key.

  2. A character value is copied into an integer data type.

  3. An arithmetic operation causes a smallint or integer value to overflow.

  4. A DEFER INTERRUPT statement is executed and the user presses the interrupt key.

Answer: D

Question No: 54

Assume a developer wants to validate the contents of a program variable against a list ofallowedvalues while executing an INPUT statement. Which validation method requires the least amountof code changes should the list of allowed values change?

  1. Referencing the list of allowed values in the INCLUDE clause of the form for the field.

  2. Comparing the entered value against a list of allowed values using a CASE statement in theAFTER FIELD block of the INPUT statement.

  3. Comparing the entered value against a list of allowed values using a CASE statement in theAFTER INPUT block of the INPUT statement.

  4. In the AFTER FIELD block of the INPUT statement, calling a validation function which quot;looksupquot;the entered value from a reference table.

Answer: D

Question No: 55

Which statements are correct about the OPEN WINDOW statement when compared to the OPENWINDOW WITH FORM statement?

  1. These statements work exactly the same way.

  2. The OPEN WINDOW WITH FORM statement does not allow the use of borders.

  3. Both statements may fail at run time if the window is too large for the terminal screen.

  4. The OPEN WINDOW statement requires you to indicate the number of rows and columns, butthe OPEN WINDOW WITH FORM does not.

Answer: C,D

Question No: 56

What is a disadvantage of using a SCROLL cursor?

  1. ORDER BY clauses are not allowed.

  2. Rows fetched with the cursor are locked.

  3. Rows are always stored in a temporary table which leads to stale data.

  4. Rows are sometimes stored in a temporary table which leads to stale data.

Answer: C

Question No: 57

What is the arr_count() 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: C

Question No: 58

When checking the return status of an SQL statement, why is it advisable to useSQLCA.SQLCODE instead of STATUS?

  1. The STATUS variable is always set by INT_FLAG.

  2. STATUS may have inadvertently been set by a 4GL application statement.

  3. The STATUS variable may have been incorrectly defined by the developer.

  4. The STATUS variable is not set by SQL statements, only by 4GL applicationstatements.

Answer: B

Question No: 59

How can the dimension of a program array be defined?

  1. dynamically by the application at run time

  2. by using the arr_count() function to set the array size

  3. by enclosing a constant in brackets when defining the array

  4. by enclosing a variable in brackets when defining the array

Answer: C

Question No: 60

How is the INSTRUCTIONS section of the form used to create screen arrays?

  1. by declaring a screen array with the key words SCREEN ARRAY

  2. by referencing the program array in the SCREEN RECORD statement

  3. by declaring the program array being referenced with the SCREEN ARRAY statement

  4. by adding the number of elements in the array after the SCREEN RECORD name in brackets

Answer: D

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

2017 EnsurePass IT Certification PDF and VCE