READ Free Dumps For Oracle- 1z0-144
| Question ID 2694 | Which two statements are true about anonymous blocks and named subprograms? (Choose two) |
| Option A | A. Subprograms are by default executed with definer's rights. |
| Option B | B. The declare section is optional for both anonymous blocks and subprograms. |
| Option C | C. Both anonymous blocks and subprograms execute by default with invoker's rights. |
| Option D | D. The declare section is mandatory for anonymous blocks and optional for subprograms. |
| Correct Answer | A,B |
| Question ID 2695 |
|
| Option A |
A. The exception raised in the code is handled by the exception handler for the PAST_DUE exception. |
| Option B | B. It does not execute because you cannot declare an exception with a similar name in the subblock. |
| Option C | C. The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subblock. |
| Option D | D. The PAST_DUE exception raised by theenclosing block is not propagated to the outer block |
| Correct Answer | D |
