C2090-913 exam

What is the primary function of the INSERT statement?A . to insert values from screen fields into the databaseB . to insert values from program variables into the databaseC . to insert values from either screen fields or program variables into the databaseD . to override the default values identified...

Which cursor type can use the FETCH PREVIOUS syntax?A . scroll cursorB . update cursorC . non-scrolling cursorD . a mobile cursor available only in D4GLView AnswerAnswer: A

Which INPUT statements are syntactically correct?A . INPUT r_record.* BY NAMEB . INPUT BY NAME r_record.*C . INPUT r_record.* FROM s_input.*D . INPUT FROM s_input.* TO r_record.*E . INPUT TO s_input.* FROM r_record.*F . INPUT BY NAME r_record.* FROM s_input.*View AnswerAnswer: BC

Why will preparing UPDATE and DELETE statements increase their execution speed?A . UPDATE and DELETE statements can NOT be prepared.B . The rows of the tables being selected will be cached in memory if the statement is prepared.C . Prepared statements are checked for syntax and optimized at prepare time,...

How is the int_flag set to true?A . The user presses the quit key.B . A character value is copied into an integer data type.C . An arithmetic operation causes a smallint or integer value to overflow.D . A DEFER INTERRUPT statement is executed and the user presses the interrupt...

Which values will the form display when using the INPUT ARRAY statement?A . nullB . the values of the program arrayC . the default attributes of the formD . the default attributes of the form or nullE . the default column values from the table definition or nullF . the...

Which statements about INFORMIX-4GL are true?A . Its programs contain modules.B . Its modules contain functions.C . The GLOBALS function is required.D . A function contains INFORMIX-4GL instructions.E . The GLOBALS function contains screen record definitions.F . Its MAIN function must be the first function in a module.G . The...

Given the following directory structure, where would you find two existing libraries for the application? (Choose two.)A . BinB . LibC . UtilD . 4GL_libView AnswerAnswer: BD

How many MAIN functions are required for an INFORMIX-4GL program?A . 0B . 1C . 2D . 3View AnswerAnswer: B

Which type of errors can be trapped by SQLCA.SQLCODE? A. compile-time errors B. user-interface errors C. application logic errors D. run-time database errorsView AnswerAnswer: D