IBM C2090-913 - Informix 4GL Development Exam
Page: 2 / 30
Total 149 questions
Question #6 (Topic: )
Which statements are true about the PREPARE statement?
A. You can use question mark syntax with the PREPARE statement.
B. A transaction is implicitly started when the statement is executed.
C. The PREPARE statement will preprocess the SQL statement before it is run.
D. The PREPARE statement is mandatory when using the SELECT and INSERT clauses.
E. It will be prepared implicitly when the cursor is opened if the SQL statement has not beenprepared explicitly.
Answer: A,C,E
Question #7 (Topic: )
Which are required for a C function call?
A. the name of the C function
B. the type of function call
C. a call to the start_fgl() function
D. any arguments passed to the C function
E. any return variables from the C function
Answer: A,D,E
Question #8 (Topic: )
Click the Exhibit button to view the exhibit. Given the exhibit, what is the stock_all_curs
beingused to do?
beingused to do?
A. re-populate the temporary table created by the stock_curs cursor
B. lock the current row of data in the database table toprevent the data from becomingstale
C. check if any new rows have been inserted into the table since the stock_curs cursorwas lasopened
D. fetch the complete row of data from the database for the primary key supplied by the stock_curs cursor
Answer: D
Question #9 (Topic: )
Which type of cursor would be most effective if a row needs to be locked while it is
examined todetermine if it should be deleted?
examined todetermine if it should be deleted?
A. scroll cursor
B. update cursor
C. non-scrolling cursor
Answer: B
Question #10 (Topic: )
Which code segment will show field-specific help at the user request during an INPUT
statement?
statement?
A. ON KEY (F1) CASE WHEN infield(a) CALL showhelp(1) WHEN infield(b) CALL showhelp(2) ... END CASE
B. INPUT BY NAME r_record.* HELP var BEFORE FIELD a LET var = 1 BEFORE FIELD b LET var = 2 ... END INPUT
C. ON KEY (F1) CASE WHEN infield(a) showhelp(1) WHEN infield(b) showhelp(2) ... END CASE
D. INPUT BY NAME r_record.* BEFORE FIELD a CALL showhelp(1) BEFORE FIELD b CALL showhelp(2) ... END INPUT
Answer: A
