Oracle Database 12c: Installation and Administration — Question 95

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

Answer options

• A. All data definition language (DDL) commands are logged in to the alert log file.
• B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
• C. A subset of executed DDL statements is written into an XML file in ADR home.
• D. A subset of executed DDL statements is written to the DDL log in ADR home.
• E. All DDL commands are logged in to a trace file in ADR home.

Correct answer: C, D

Explanation

The correct answers are C and D because when ENABLE_DDL_LOGGING is set to TRUE, a subset of DDL statements is logged in an XML format within the ADR home and also specifically recorded in the DDL log. Options A, B, and E are incorrect as they suggest logging in formats or locations that do not occur with this setting.