READ Free Dumps For Oracle- 1z0-144
Question ID 2688 | View Exhibit 1 and examine the structure of the EMP table. |
Option A | A. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect. |
Option B | B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package. |
Option C | C. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect. |
Option D | D. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package. |
Correct Answer | B |
Question ID 2689 | Examine the following PL/SQL code: |
Option A | A. Each fetch retrieves the first row and assigns values to the target variables. |
Option B | B. Each fetch retrieves the next consecutive row and assigns values to the target variables. |
Option C | C. They produce an error because you must close and reopen the cursor before each fetch - statement. |
Option D | D. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error. |
Correct Answer | B |