- All Exams Instant Download
Given the code segment in the exhibit, which WHENEVER statement is active after exiting the IF statement?
Click the <<ItemExhibitName>> button to view the exhibit. Given the code segment in the exhibit, which WHENEVER statement is active after exiting the IF statement?A . WHENEVER ERROR STOPB . WHENEVER ERROR CONTINUEC . WHENEVER ERROR CALL ERROR_LOGView AnswerAnswer: B
What happens to an open transaction if the 4GL program terminates?
What happens to an open transaction if the 4GL program terminates?A . No database changes are saved.B . The transaction is closed and all work is saved.C . All database work since the start of the transaction is saved.D . The program automatically prompts to complete the transaction.E . The...
Which statements are true about SQLCA?
Which statements are true about SQLCA? A. SQLCA is implicitly defined. B. SQLCA.SQLCODE and STATUS will always contain the same values. C. One copy of the SQLCA structure is defined for each SQL statement. D. SQLCA is an abbreviation for Structured Query Language Communications Access.View AnswerAnswer: AD
When checking the return status of 4GL application statements such as PROMPT, why is it advisable to use STATUS instead of SQLCA.SQLCODE?
When checking the return status of 4GL application statements such as PROMPT, why is it advisable to use STATUS instead of SQLCA.SQLCODE? A. The STATUS variable is always set by INT_FLAG. B. The SQLCA.SQLCODE variable may have been incorrectly defined by the developer. C. The STATUS variable is not set...
Given the code in the exhibit, what will be the state of the database if the procedure st_update succeeds and st_insert fails?
Click the <<ItemExhibitName>> button to view the exhibit. Given the code in the exhibit, what will be the state of the database if the procedure st_update succeeds and st_insert fails?A . It depends on the ANSI MODE state of the database.B . The changes made by st_update and st_insert are...
Given the form in the exhibit, which code segment would properly add 10 days to the input contents of field a and display the results in field b?
Click the <<ItemExhibitName>> button to view the exhibit. Given the form in the exhibit, which code segment would properly add 10 days to the input contents of field a and display the results in field b?A . AFTER FIELD a LET r_record.b = r_record.a + 10 DISPLAY BY NAME r_record.bB...
What can a scroll cursor do?
What can a scroll cursor do?A . scroll in a forward direction only through a data setB . scroll in a backward direction only through a data setC . scroll in a forward and backward direction through a data setD . scroll in a forward direction and locking each row...
Which code segment will show field-specific help at the user s request during an INPUT statement?
Which code segment will show field-specific help at the user s request during an INPUT statement?A . ON KEY (F1) CASE WHEN infield(a) CALL showhelp(1) WHEN infield(b) CALL showhelp(2) ... END CASEB . INPUT BY NAME r_record.* HELP var BEFORE FIELD a LET var = 1 BEFORE FIELD b LET...
What is the CONSTRUCT statement used for?
What is the CONSTRUCT statement used for?A . to include user input in SQL queriesB . to arrange an array of program variablesC . to pre-optimize a statement before beginning a queryD . to build an arbitrarily complex data structure in memoryView AnswerAnswer: A
After which event is a cursor declared WITH HOLD closed?
After which event is a cursor declared WITH HOLD closed?A . After the transaction ends.B . After another cursor is opened.C . After the CLOSE statement is executed.D . After the function currently executing is exited.E . After the last row from the active set is fetched.View AnswerAnswer: C
