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.
A
A seems correct until you read the last bit – “…in the trace file.” Looking at D though – DDL like create tablespace are definitely logged irrespective of the value for enable_ddl_logging.
I’d plump for D as the correct answer.
A, not D
I have checked adding a new datafile with enable_ddl_logging=false and this DDL is logged and it is indeed true for all versions of oracle to log new datafile creation to be loggeged.
So correct answer is D.
SQL> show parameter enable_dd
NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean FALSE
Fri Sep 19 15:20:09 2014
alter tablespace users add datafile ‘/u01/app/oracle/oradata/db2/users02.dbf’ size 50M
Completed: alter tablespace users add datafile ‘/u01/app/oracle/oradata/db2/users02.dbf’ size 50M
Not A and not D, but A is closest.
Not A, because it is just a SUBSET of DDL, not all.
Not D, because the same, not just the creation of database files
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.
https://docs.oracle.com/database/121/REFRN/refrn10302.htm
I would go with A.
A, for sure.
If you set the enable_ddl_logging parameter to true, the instance will record the DDL changes in the log.xml file. If you don’t set this parameter to true, Oracle won’t record these changes to the log.xml or the alert log.
A