Oracle
1Z0-146 · Question #3
Examine the following settings for a session: PLSQL_CODE_TYPE = NATIVE PLSQL_OPTIMIZE_LEVEL = 3 Which statement would be true in this scenario?
The correct answer is A. The compiler would automatically inline subprograms. 3 - Applies a wide range of optimization techniques beyond those of level 2, automatically including techniques not specifically requested.
Managing Program Units
Question
Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE PLSQL_OPTIMIZE_LEVEL = 3 Which statement would be true in this scenario?
Options
- AThe compiler would automatically inline subprograms.
- BThe compiler would inline the code for external subroutines.
- CThe compiler would inline the code even if the INLINE pragma is set to NO.
- DThe compiler would not inline the code unless the INLINE pragma is set to YES.
How the community answered
(35 responses)- A83% (29)
- B3% (1)
- C3% (1)
- D11% (4)
Explanation
3 - Applies a wide range of optimization techniques beyond those of level 2, automatically including techniques not specifically requested.
Topics
#PLSQL_CODE_TYPE#NATIVE compilation#INLINE pragma#optimization level
Community Discussion
No community discussion yet for this question.