Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
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.
Enjoyed examining this, very good stuff, appreciate it.
http://www.bastcilkdoptb.com/
C
E
https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302
“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”
I think E is correct.
We like to honor quite a few other net web-sites on the internet, even when they arent linked to us, by linking to them. Below are some webpages worth checking out.
C is right.. The log files will be located in /log/ddl directory
E is the correct answer.
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.
https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302
As usual whith OCP tests nothing is correct.
A/ is not correct because successfull DDL is logged
B/ is not correct because it does not write to alert log
C/ is not correct because log/ddl_.log file entries do NOT contain any timestamps
D/ is not correct because also DDL which does not create new segments is logged
E/ is not correct because xml file is in log/ddl directory
And now make your choice.
But xml file has timestamps, so C is correct.