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.
Explanation:
ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL)
statements to a DDL alert log.
The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL
statements issued by the database. The DDL log is created only for the RDBMS component and only if the
ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL
statements are not included in any log.