Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

Question

Options

• AOnly the data definition language (DDL) commands that resulted in errors are logged in the alert
• BAll DDL commands are logged in the alert log file.
• CAll DDL commands are logged in a different log file that contains DDL statements and their
• DOnly DDL commands that resulted in the creation of new segments are logged.
• EAll DDL commands are logged in XML format in the alert directory under the Automatic

• A
  2% (1)
• B
  3% (2)
• C
  8% (5)
• E
  87% (54)

Explanation

https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0- A97EC1C721AE.htm 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.

No community discussion yet for this question.