READ Free Dumps For Oracle- 1z0-144
| Question ID 2722 | Which two statements are true about the exit statement encountered in loop? (Choose two) |
| Option A | A. The PL/SQL block execution terminates immediately after the exit statement. |
| Option B | B. The loop completes immediately and control passesto the statement after end loop |
| Option C | C. The statements after the exit statement in the Iteration are not executed before terminating the LOOP. |
| Option D | D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop. |
| Correct Answer | B,D |
| Question ID 2723 | Which two statements are true about database triggers? (Choose two.) |
| Option A | A. Each trigger can be of any size. |
| Option B | B. Each trigger can be of a maximum size of 32 KB. |
| Option C | C. A trigger can contain a maximum of 32 lines of code. |
| Option D | D. Triggers fired by DML statements cannot cascade simultaneously. |
| Option E | E. Both DML and DDL statements cancascade any number of triggers, |
| Option F | F. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers |
| Correct Answer | B,E |