Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
Setting enable_ddl_logging to TRUE results in all data definition language (DDL) commands being logged in a separate log file that contains both the DDL statements and their execution dates. This log is distinct and contains comprehensive records of all DDL activities.
I think C is the right answer.
E is correct https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302
C is correct. DDL command are loged in separate log files 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
it would appear that none are correct when oracle docs reads a subset of DDL is logged not "ALL" "ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log." -https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302 C would be the closet to being correct.
#297 see
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. So E is incorrect
E is correct. #297 - D is "All DDL commands are logged in to a trace file in ADR home." which is incorrect (trace file).
E is correct. #297 - D is "All DDL commands are logged in to a trace file in ADR home." which is incorrect (trace file).
E is correct, it's different. #297 is another question
https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302 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.
.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.