- All Exams Instant Download
What is one advantage of using INFORMIX-4GL C-compiled version versus INFORMIX-4GL RDS?
What is one advantage of using INFORMIX-4GL C-compiled version versus INFORMIX-4GL RDS?A . It compiles faster.B . It executes the program faster.C . It uses the INFORMIX-4GL Interactive Debugger.D . It readily accesses a graphical presentation of your application.View AnswerAnswer: B
Given the exhibit, which rows will the DELETE statement delete?
Click the <<ItemExhibitName>> button to view the exhibit. Given the exhibit, which rows will the DELETE statement delete?A . all of the rowsB . all rows except those rows with a stock_num equal to fiveC . only those rows with descriptions of baseball and footballD . only those rows with...
Which statements are true about the INSERT statement?
Which statements are true about the INSERT statement?A . The INSERT statement can be used with a cursor.B . A form must be open and displayed to perform an INSERD . A single INSERT statement can insert rows into multiple tables.E . Every column in the table must be referenced...
What happens when the last statement in the code sample in the exhibit is executed?
Click the <<ItemExhibitName>> button to view the exhibit. What happens when the last statement in the code sample in the exhibit is executed? A. Row 0 is fetched into sel_var. B. The run-time error is generated. C. The value of SQLCA.SQLCODE will equal NOTFOUND. D. The last row in the...
What must be done prior to using an EXECUTE statement for an INSERT statement?
What must be done prior to using an EXECUTE statement for an INSERT statement?A . SERIAL numbers must be assigned.B . The INSERT must have been prepared.C . All columns must have non-NULL values.D . An INSERT CURSOR must have been declared.View AnswerAnswer: B
Which two functions must be created to determine the maximum purchase order amount that a user is authorized to enter?
The end users at your client site require the ability to enter purchase orders online. Management has agreed to allow the users to perform this function, but with some restrictions. End users will be classified as one of three categories: Each category of employee will have the following limits on...
Given the exhibit, which 4GL statements are involved in passing and returning values?
Click the <<ItemExhibitName>> button to view the exhibit. Given the exhibit, which 4GL statements are involved in passing and returning values?A . IFB . LETC . DEFINED . RETURNView AnswerAnswer: AD
Which statements are true about the WHENEVER ERROR statement options?
Which statements are true about the WHENEVER ERROR statement options?A . WHENEVER ERROR STOP terminates the program immediately on receipt of an error.B . WHENEVER ERROR CONTINUE continues execution on receipt of an error and data NOTFOUND condition.C . WHENEVER ERROR STOP terminates the program immediately, for all error and...
Which are valid statements?
Which are valid statements?A . SET LOCK MODE TO WAITB . SET DEADLOCK MODE OFFC . SET ISOLATION TO CURSOR STABILITYD . OPTIONS ISOLATION LEVEL DIRTY READE . SET TRANSACTION TO REPEATABLE READView AnswerAnswer: AC
Given the segment of code in the exhibit, what is the appropriate text for the variable what_error_message?
Click the <<ItemExhibitName>> button to view the exhibit. Given the segment of code in the exhibit, what is the appropriate text for the variable what_error_message?A . The serial number you entered is not valid.B . Duplicate equipment records are not allowed.C . Equipment was not found, please re-enter the serial...
