Oracle Database: Advanced PL/SQL — Question 60

Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

Answer options

• A. Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
• B. The default value is NATIVE.
• C. If set to NATIVE, programs are stored in platform dependent machine code.
• D. It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
• E. If set to NATIVE, programs are stored in a PL/SQL bytecode format.

Correct answer: C, D

Explanation

Option C is correct because when the PLSQL_CODE_TYPE is set to NATIVE, it indeed stores programs as platform-dependent machine code. Option D is also correct as it allows the recompilation of a program unit while maintaining the current session settings. The other options are incorrect because A misrepresents the behavior of the parameter, B incorrectly states the default value, and E describes the storage format incorrectly.