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

Place holders for program variables to be supplied later may be used in PREPARE statements inwhich locations?

  1. in the TABLE name

  2. in the WHERE clause

  3. in the ORDER BY statement

  4. in the SET clause of UPDATE statements

  5. in the VALUES clause of INSERT statements

Answer: B,D,E

Question No: 42

Which statements will be interrupted if the DEFER INTERRUPT statement has been executedand the user presses the interrupt key?

  1. INPUT

  2. CONSTRUCT

  3. INPUT ARRAY

  4. OPEN CURSOR

  5. START REPORT

Answer: A,B,C

Question No: 43

Which statement is syntactically correct?

  1. INPUT ARRAY ga_manufact FROM sa_manufact.*

  2. INPUT ARRAY ga_manufact[*] FROM sa_manufact

  3. INPUT ARRAY ga_manufact.* FROM sa_manufact.*

  4. INPUT ARRAY ga_manufact[].* FROM sa_manufact.*

Answer: A

Question No: 44

Given this statement, if the customer table contains a SERIAL column, which

statementshouldbe executed prior to the INSERT? INSERT INTO customer VALUES (gr_cust.*)

  1. INITIALIZE gr_cust.* TO 0

  2. LET gr_cust.serialnum = 0

  3. LET gr_cust.serialnum = NULL

  4. No extra statements for SERIAL values are needed if gr_cust was defined with the statement:

DEFINE gr_cust RECORD LIKE customer.*

Answer: B

Question No: 45

Click the Exhibit button to view the exhibit. Given the exhibit, how will the INPUT ARRAY reactwhen the user leaves the code field?

  1. If the code already exists, then an error will be displayed to the user, and the cursor will moveto the sname field.

  2. If the code does NOT already exist, than an error will be displayed to the user, and the cursorwill move to the sname field.

  3. If the code already exists, then an error will be displayed to the user, the cursor will stay in thecode field, and the user must re-enter a state code.

  4. If the code does NOT already exist, then an error will be displayed to the user, and the cursorwill stay in the code field, and the user must re-enter a state code.

Answer: C

Question No: 46

What happens if the record is defined with the LIKE clause, and some of theunderlying table columns are dropped?

  1. The next time the program is run, the record will be re-built, removing the dropped columns.

  2. The ALTER TABLE statement automatically updates any programs referencing the

    droppedcolumns.

  3. The next time the program is run, an error will occur if the SELECT statement contains therecord.

  4. The next time the program is run, a warning will occur if the SELECT statement contains therecord.

Answer: C

Question No: 47

Which are valid statements?

  1. SET LOCK MODE TO WAIT

  2. SET DEADLOCK MODE OFF

  3. SET ISOLATION TO CURSOR STABILITY

  4. OPTIONS ISOLATION LEVEL DIRTY READ

  5. SET TRANSACTION TO REPEATABLE READ

Answer: A,C

Question No: 48

What is the primary function of the INSERT statement?

  1. to insert values from screen fields into the database

  2. to insert values from program variables into the database

  3. to insert values from either screen fields or program variables into the database

  4. to override the default values identified to the database in the CREATE DATABASE statement

Answer: B

Question No: 49

Click the Exhibit button to view the exhibit. Given the exhibit, where should the OPEN

statementfor the cursor be for a transaction logging database?

  1. it does not matter

  2. within a transaction

  3. outside a transaction

  4. in the same function as a transaction

Answer: B

Question No: 50

Why will preparing UPDATE and DELETE statements increase their execution speed?

  1. UPDATE and DELETE statements can NOT be prepared.

  2. The rows of the tables being selected will be cached in memory if the statement is prepared.

  3. Prepared statements are checked for syntax and optimized at prepare time, not at executiontime.

  4. Memory is allocated for the results set which will be returned from the SELECT statement atprepare time.

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