READ Free Dumps For Oracle- 1z0-144
Question ID 2666 | Which two statements are true about the usage of the cursor for loops? (Choose two.) |
Option A | A. The cursor needs to be closed after the iteration is complete. |
Option B | B. The implicit open, fetch, exit, and close of the cursor happen. |
Option C | C. The record type must be explicitly declared to control the loop. |
Option D | D. The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set. |
Correct Answer | B,D |
Question ID 2668 | Consider the following scenario: |
Option A | A. Procedure A is invalidated and recompiled immediately. |
Option B | B. There is no effect on procedure A and it runs successfully. |
Option C | C. Procedure B is invalidated and recompiled again when invoked. |
Option D | D. Procedure A is invalidated and recompiles when invoked the next time. |
Correct Answer | D |