Oracle Database: Program with PL/SQL — Question 8

Which three commands can be used to set PL/SQL conditional compilation inquiry directive MODE?

Answer options

• A. ALTER SESSION SET PLSQL_CCFLAGS = ‘mode: FALSE’;
• B. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: NULL’;
• C. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: Level 1’;
• D. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: Level1’;
• E. ALTER SESSION SET PLSQL_CCFLAGS= ‘mode: 1’

Correct answer: A, C, E

Explanation

The correct answers are A, C, and E because they properly set the PL/SQL conditional compilation inquiry directive MODE to valid values. Option B is incorrect as 'NULL' is not a valid mode setting, and option D is incorrect due to the lack of a space in 'Level1', which is not recognized as a standard mode level.