Oracle Database 12c: Installation and Administration — Question 65

Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)

Answer options

• A. All data definition language (DDL) statements are written to the control file
• B. Some DDL statements are written to an XML file in the ADR home
• C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
• D. Some data definition language (DDL) statements are written to the control file
• E. Some DDL statements are written to a text file in the ADR home
• F. The Alert Log still contains some DDL statements

Correct answer: B, E

Explanation

The correct answers are B and E because when ENABLE_DDL_LOGGING is set to TRUE, specific DDL statements are logged in an XML format in the ADR home as well as in text files. Options A, C, and D are incorrect since not all DDL statements are logged to the control file, and the logging does not apply to everything in the ADR home.