Oracle Database 12c: Installation and Administration — Question 60

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

Answer options

• A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B. All DDL commands are logged in the alert log file.
• C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D. Only DDL commands that resulted in the creation of new segments are logged.
• E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Correct answer: E

Explanation

The correct answer is E, as enabling DDL logging captures all DDL commands in XML format in the ADR home alert directory. Options A, B, C, and D are incorrect as they incorrectly describe the logging behavior or the format in which DDL commands are recorded.