C2090-913

When is the column-list optional in the INSERT statement?A . neverB . if a SERIAL column is being usedC . when the value list is also optionalD . when values are supplied for each column in the target tableView AnswerAnswer: D

After a user-interrupt sets the int_flag to TRUE, how can it be reset to FALSE?A . by INFORMIX-4GL after 1 second has elapsedB . by executing the DEFER INTERRUPT statementC . only if the application code resets it to FALSED . by INFORMIX-4GL after the IF int_flag statement is executedView...

While running a 4GL application that utilizes cursors heavily, what can you do if the amount of free memory falls dangerously low?A . Use the END "cursorname" statement after using a cursor.B . Use the DROP "cursorname" statement after using a cursor.C . Use the FREE "cursorname" statement after using...

Which statement will correctly call a function within a conditional expression?A . IF check_security (lastname) = TRUE THEN GOTO :done END IFB . IF check_security = lastname = TRUE THEN GOTO :done END IFC . IF CALL check_security (lastname) = TRUE THEN GOTO :done END IFD . IF check_security ()...

Click the <<ItemExhibitName>> button to view the exhibit. Given the code in the exhibit, which statement is correct? A. The WHENEVER ERROR CONTINUE is active while in function A. B. The WHENEVER ERROR CONTINUE is active when function B is called. C. The WHENEVER ERROR STOP is active for MAIN,...

Which are valid clauses of an INPUT statement?A . ON KEYB . ON ANY KEYC . ON LAST KEYD . ON INPUT WRAPE . BEFORE/AFTER KEYF . BEFORE/AFTER INPUTG . BEFORE/AFTER FIELDH . BEFORE/AFTER INTERRUPTView AnswerAnswer: AFG

Click the <<ItemExhibitName>> button to view the exhibit. Given the exhibit, what is the stock_curs cursor being used to do?A . supply an "index of primary keys" to the stock_all_cursB . lock the current row of data in the database table to prevent the data from becoming staleC . check...

Which statements will be interrupted if the DEFER INTERRUPT statement has been executed and the user presses the interrupt key?A . INPUTB . CONSTRUCTC . INPUT ARRAYD . OPEN CURSORE . START REPORTView AnswerAnswer: ABC

In which statements must parameters to a function be defined?A . in the CALL statementB . in the RETURN statementC . in the DEFINE statementD . in the FUNCTION statementView AnswerAnswer: C

What is the effect of the WITHOUT DEFAULTS clause of an INPUT statement?A . It initializes the program variables to NULC . It prevents user input of DEFAULT values in the form.D . It prevents the program variables from being initialized to NULF . It initializes the program variables to...