QUESTION 22-enable_ddl_logging

Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?
A. None of the data definition language (DDL) statements are logged in the trace file.
B. Only DDL commands that resulted in errors are logged in the alert log file.
C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
D. Only DDL commands that resulted in the creation of new database files are logged.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
Explanation:
ENABLE_DDL_LOGGING启用或禁用DDL (data definition language，数据定义语言)语句的子集写入DDL告警日志。DDL日志是一个文件，具有与警报日志相同的格式和基本行为，但它只包含数据库发出的DDL语句。只有当初始化参数ENABLE_DDL_LOGGING设置为true时，才会为RDBMS组件创建DDL日志。当该参数设置为false时，DDL语句将不包含在任何日志中。