READ Free Dumps For Oracle- 1z0-144
| Question ID 2692 | View Exhibit 1 and examine the structure of the EMP and dept tables.
What is the outcome on compilation? |
| Option A | A. It compiles and executes successfully. |
| Option B | B. It gives an error on compilation because it is not a row-level trigger. |
| Option C | C. It gives an error on compilation because the exception section Is used in the trigger. |
| Option D | D. It compiles successfully but gives an error on execution because it is not a row-level trigger |
| Correct Answer | B |
| Question ID 2693 | Which two statements are true about the PL/SQL initialization parameters? (Choose two.) |
| Option A | A. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l. |
| Option B | B. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance. |
| Option C | C. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations. |
| Option D | D. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled |
| Correct Answer | B,C |