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
A.
None of the data definition language (DDL) statements are logged in the trace file.
C
Sorry, ะก when value is TRUE.
correct answer is A.
I thing D
I test on O12c and when prameter is FALSE DDL command like create tablespace is loged in alertlog TXT and XML
Thu Feb 05 11:36:12 2015
XDB installed.
XDB initialized.
create tablespace m1 datafile ‘c:\m1’ size 10m
Completed: create tablespace m1 datafile ‘c:\m1’ size 10m
create tablespace m2 datafile ‘c:\m2’ size 10m
Completed: create tablespace m2 datafile ‘c:\m2’ size 10m
Thu Feb 05 11:55:45 2015
drop tablespace m2
Completed: drop tablespace m2
alter tablespace m1 add datafile ‘c:\m11’ size 10m
Completed: alter tablespace m1 add datafile ‘c:\m11’ size 10m
I THINK THERE IS NO CORRECT ANSWER.
https://docs.oracle.com/database/121/REFRN/refrn10302.htm#REFRN10302
Default Value: FALSE
ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL 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.
The DDL log contains one log record for each DDL statement issued by the database. The DDL log is included in IPS incident packages.
There are two DDL logs that contain the same information. One is an XML file, and the other is a text file. The DDL log is stored in the log/ddl subdirectory of the ADR home.
When ENABLE_DDL_LOGGING is set to true, the following DDL statements are written to the log:
ALTER/CREATE/DROP/TRUNCATE CLUSTER
ALTER/CREATE/DROP FUNCTION
ALTER/CREATE/DROP INDEX
ALTER/CREATE/DROP OUTLINE
ALTER/CREATE/DROP PACKAGE
ALTER/CREATE/DROP PACKAGE BODY
ALTER/CREATE/DROP PROCEDURE
ALTER/CREATE/DROP PROFILE
ALTER/CREATE/DROP SEQUENCE
CREATE/DROP SYNONYM
ALTER/CREATE/DROP/RENAME/TRUNCATE TABLE
ALTER/CREATE/DROP TRIGGER
ALTER/CREATE/DROP TYPE
ALTER/CREATE/DROP TYPE BODY
DROP USER
ALTER/CREATE/DROP VIEW
See the statement in your description “When this parameter is set to false, DDL statements are not included in any log.” Clearly says that non DDL statements are logged when this value is FALSE.
I think NONE as well, but likely the answer is A. Answer D says “only ddl commands that resulted in the CREATION of new database files …” but from Jan’s answer above, we see also DROP and ALTER ddl available in the log, so it captures more than just CREATION of new data files it also still captures DROP and ALTER. But since you can;t choose NONE OF THE ABOVE on this question, and since A,B and C are definitely wrong, it must be A.
oops, I meant likely the answer is D, not A. sorry
A
A is correct. Once its set to False none of the DDLs will be logged into either log files or tracefiles.
A
I have tested the above scenario. The correct answer is both (A) and (D).
D is correct
SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean FALSE
SQL> alter tablespace users add datafile;
Tablespace altered.
Log file:
===================
2015-09-08 16:28:04.842000 +02:00
alter tablespace users add datafile
Completed: alter tablespace users add datafile
The above might be true but for the exam, the oracle docs say A, no logging recorded.
The correct answer is A.
https://docs.oracle.com/cloud/latest/db121/REFRN/refrn10302.htm#REFRN10302
“When this parameter is set to false, DDL statements are not included in any log.”
Management of tablespaces is not DDL, it is a administrative task.
D is correct.
Tested thoroughly on 12c db on Linux 5u10
A
No ddl recording in alert log
A is correct.
D is incorrect for several reasons. DDLs create or manage schema objects and privs, not tablespaces or databases. Secondly, option D says “Only DDLs that result in DB files creation”. Alert file records much more actions so such limiting is incorrect anyway.
A or D? Depends on your definition of DDL.
DDL = Data Definition Language. Anything that gets recorded in the data dictionary should qualify as DDL, so create datafile is DDL, alter system is no DDL.
Also, if you set the parameter to TRUE, the add datafile commands get included in the DDL log, so apparently Oracle considers them to be DDL too.
I would choose D.
A is correct as , it’s saying
“None of the data definition language (DDL) statements are logged in the trace file.”
Note the point here, trace file, not the alertlog
So answer A is correct.