Oracle Database: Program with PL/SQL — Question 72

Which two statements are correct in Oracle Database 12c?

Answer options

• A. For native compilation, PLSQL_OPTIMIZE_LEWVEL should be set to 2.
• B. Native compilation is the default compilation method
• C. Native compilation should be used during development.
• D. Natively compiles code is stored in the SYSTEM tablespace.
• E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile it.

Correct answer: D, E

Explanation

Option D is correct because natively compiled code is indeed stored in the SYSTEM tablespace. Option E is also correct, as it accurately describes the process to convert a PL/SQL object to native code. The other options are incorrect because they provide inaccurate information about compilation settings and defaults.