Ques 136. The command used to open a CURSOR FOR loop is
1. open 2. fetch 3. parse 4. None, cursor for loops handle cursor opening implicitly.
Is it helpful?
Add CommentView Comments
Ques 137. What happens when rows are found using a FETCH statement
1. It causes the cursor to close
2. It causes the cursor to open
3. It loads the current row values into variables
4. It creates the variables to hold the current row values
The answer is: It loads the current row values into variables.
Is it helpful?
Add CommentView Comments
Ques 138. Under which circumstance must you recompile the package body after recompiling the package specification?
1. Altering the argument list of one of the package constructs 2. Any change made to one of the package constructs 3. Any SQL statement change made to one of the package constructs 4. Removing a local variable from the DECLARE section of one of the package constructs
Is it helpful?
Add CommentView Comments
Ques 139. Procedure and Functions are explicitly executed. This is different from a database trigger. When is a database trigger executed?
1. When the transaction is committed 2. During the data manipulation statement 3. When an Oracle supplied package references the trigger 4. During a data manipulation statement and when the transaction is committed
Is it helpful?
Add CommentView Comments
Ques 140. Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus?