Which two statements are true in this scenario?

Examine the command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true in this scenario? (Choose two.)
A. All data definition language (DDL) commands ae logged in to the alert log file.
B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
C. A subset of executed DDL statements is written into an XML file in ADR home.
D. A subset of executed DDL statements is written to the DDL log in ADR home.
E. All DDL commands are logged in to a trace file in ADR home.

Download Printable PDF. VALID exam to help you PASS.

One thought on “Which two statements are true in this scenario?

  1. C, D

    https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302

    (a) ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log.

    (b) 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.

    Therefore, it follows that the writing of a subset of DDL to a DDL log happens to both an XML file as well as a DDL text log in the ADR Home – though they are not subsets of each other, they are duplicatess – but both statements are true.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.