READ Free Dumps For Oracle- 1z0-144
| Question ID 2706 | Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply) |
| Option A | A. It can be the first exception handler. |
| Option B | B. It can be the only exception handler for the code. |
| Option C | C. It traps all the exceptions that are not already trapped. |
| Option D | D. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions. |
| Correct Answer | C |
| Question ID 2707 |
What is the outcome? |
| Option A | A. It gives an error because the return type is not valid. |
| Option B | B. It gives an error because the record type is not defined within the function |
| Option C | C. It gives an error because the function call in DBMS_OUTPUT. PUT__LINEis not valid |
| Option D | D. It executes successfully and displays the names and salaries of all employees who earn the highest salary. |
| Option E | E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary. |
| Correct Answer | D |
