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

The correct answer is C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates. DLL 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.

New Features for Manageability

Question

Options

AOnly the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
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 execution dates.
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 Diagnostic Repository

How the community answered

(31 responses)

C
90% (28)
D
6% (2)
E
3% (1)

Explanation

DLL 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.

Topics

#DDL logging#enable_ddl_logging#ADR#diagnostic log

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice