- All Exams Instant Download
Given this statement, if the customer table contains a SERIAL column, which statement should be executed prior to the INSERT?
Given this statement, if the customer table contains a SERIAL column, which statement should be executed prior to the INSERT? A . INITIALIZE gr_cust.* TO 0B . LET gr_cust.serialnum = 0C . LET gr_cust.serialnum = NULLD . No extra statements for SERIAL values are needed if gr_cust was defined with...
A cursor defined WITH HOLD gets closed when which statement is executed?
A cursor defined WITH HOLD gets closed when which statement is executed?A . BEGIN WORKB . COMMIT WORKC . ROLLBACK WORKD . END TRANSACTIONE . CLOSE cursor_nameView AnswerAnswer: E
When would you want to use both STATUS and SQLCA.SQLCODE?
When would you want to use both STATUS and SQLCA.SQLCODE? A. When using the C-compiled version of 4GL. B. Never. Programs should use either method exclusively. C. For portability because certain 4GL ports support STATUS and others require SQLCA.SQLCODE. D. The program needs to execute 4GL application statements prior to...
Given the exhibit, if error -113 occurred after executing the INSERT statement, which error message would display?
Click the <<ItemExhibitName>> button to view the exhibit. Given the exhibit, if error -113 occurred after executing the INSERT statement, which error message would display?A . Error -113 has occurred.B . ERROR DURING INSERT -113.C . None, the error would be ignored.View AnswerAnswer: A
What is a transaction log?
What is a transaction log?A . an accounting record of database changesB . a journal of changes made during a transactionC . a location where ERRORLOG() messages are storedD . a recorded set of errors received from the SQLCA structureView AnswerAnswer: B
Why is the line "LET int_flag = FALSE" and its placement in the code segment important?
Click the <<ItemExhibitName>> button to view the exhibit. Why is the line "LET int_flag = FALSE" and its placement in the code segment important?A . It disallows users from interrupting the CONSTRUCT phase.B . Integer fields are to be skipped during the CONSTRUCT phase.C . The interrupt may have been...
Which functions can be used within a conditional expression?
Which functions can be used within a conditional expression?A . FUNCTION funca() DEFINE ret_code integer LET ret_code = 10 END FUNCTIONB . FUNCTION funca() DEFINE ret_code integer LET ret_code = 10 RETURN ret_code END FUNCTIONC . FUNCTION funca() DEFINE ret_code integer LET ret_code =10 LET ret_code2 = 20 RETURN ret_code,...
Which statements can be interrupted once a DEFER INTERRUPT has been set?
Which statements can be interrupted once a DEFER INTERRUPT has been set?A . INPUTB . PROMPTC . DISPLAY FORMD . DECLARE CURSORView AnswerAnswer: AB
Given the code segment in the exhibit, which variable is passed to the function?
Click the <<ItemExhibitName>> button to view the exhibit. Given the code segment in the exhibit, which variable is passed to the function?A . lastnameB . firstnameC . account_nbrD . account_codeView AnswerAnswer: C
Given the form in the exhibit, which code segment would properly add 10 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 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 ....
