Oracle
1Z0-144 · Question #29
Which two statements are true about the PL/SQL initialization parameters? (Choose two.)
The correct answer is B. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for C. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for. See the full explanation below for the reasoning.
Question
Which two statements are true about the PL/SQL initialization parameters? (Choose two.)
Options
- ATo use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or
- BThe default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for
- CSetting PLSQL_CODE_TYPE to native provides the greatest performance gains only for
- DChanging the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units
How the community answered
(63 responses)- A14% (9)
- B76% (48)
- D10% (6)
Community Discussion
No community discussion yet for this question.