READ Free Dumps For Oracle- 1z0-144
| Question ID 2727 | View the exhibit to examine the PL/SQL code. |
| Option A | A. All the exceptions in the code are trapped by the exception handler. |
| Option B | B. All the "no data found" errors in the code are trapped by the exception handler. |
| Option C | C. The PL/SQL program does not execute because an exception is not declared in the declare section. |
| Option D | D. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code. |
| Correct Answer | B |
| Question ID 2728 | View the Exhibit to examine the PL/SQL code. |
| Option A | A. The execution fails because of the misplaced else clause. |
| Option B | B. The execution is successful even if there is no employee with EMPLOYEE_ID 115. |
| Option C | C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found. |
| Option D | D. The execution is successful, but it displays an incorrect output if no employee withEMPLOYEE_ID 115 is found.
|
