C2090-913 exam

Which statements can be used in an INPUT statement control block?A . showhelp(23)B . NEXT ROW PRIORC . NEXT FIELD NEXTD . CALL showhelp(23)E . NEXT FIELD PREVIOUSF . PROMPT "text" FOR CHAR variableView AnswerAnswer: CDE

What must be true for this statement to execute? A . The statement must be prepared.B . gr_cust must be a global variable.C . gr_cust must contain non-null values.D . gr_cust must have a structure like the customer table.View AnswerAnswer: D

Which ISOLATION level should be used when writing a batch report that can ignore incomplete transactions?A . DIRTY READB . COMMITTED READC . REPEATABLE READD . CURSOR STABILITYView AnswerAnswer: A

Which errors are 4GL run-time errors?A . having a syntax error in an unprepared SQL statementB . executing a 4GL WHILE statement without a matching END WHILEC . inserting a row into a table without the user having table insert permissionD . adding an integer number into a variable declared...

What is a computer file of INFORMIX-4GL instructions called?A . the formB . the moduleC . the programD . the functionView AnswerAnswer: B

How can you programmatically determine the SERIAL value assigned after inserting a row?A . Use the get_diagnostics() function.B . Define a 4GL variable of type SERIAD . Check the value in the SQLCA structure.E . Track the SERIAL value in a program variable.View AnswerAnswer: C

What is the purpose of a cursor?A . to retrieve one or more rows from the databaseB . to allow the programmer to view the entire databaseC . to fetch multiple rows from the database simultaneouslyD . to ensure database integrity by enforcing security rulesView AnswerAnswer: A

What are characteristics of INFORMIX-4GL RDS?A . It provides a graphical user interface.B . It can use the INFORMIX-4GL Interactive Debugger.C . It compiles faster than INFORMIX-4GL Compiled Version.D . It executes faster than INFORMIX-4GL Compiled Version.View AnswerAnswer: BC

Click the <<ItemExhibitName>> button to view the exhibit. In the exhibit, assuming all of the program variables have been populated with the appropriate data, which statement should be used to put the values into the employee table?A . INSERT INTO employee VALUES (*)B . INSERT INTO employee VALUES (gr_employee.*)C ....

What is the proper method for inserting a value into a column assigned a data type of SERIAL?A . Set the program variable for the serial column to NULC . Set the program variable for the serial column to zero.D . Set the program variable for the serial column to...