READ Free Dumps For Oracle- 1z0-144
| Question ID 2690 | View Exhibit1 and examine the structure of the employees table. |
| Option A | A. Both blocks compile and execute successfully when called. |
| Option B | B. Both blocks compile successfully but the CALC_SAL procedure gives an error on execution. |
| Option C | C. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure. |
| Option D | D. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function. |
| Correct Answer | A |
| Question ID 2691 | Examine the following PL/SQL code: |
| Option A | A. The code executes successfully and gives the desired output. |
| Option B | B. The code generates an error because the EMP_RECORD variable is not declared. |
| Option C | C. The code generates an error because the cursor is not opened before the FOR loop. |
| Option D | D. The code generates an error because the loop does not have the exit when clause. |
| Correct Answer | A |
