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

The correct answer is A. None of the data definition language (DDL) statements are logged in the trace file. ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL alert 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…

New Features for Manageability

Question

Examine the following command:

ALTER SYSTEM SET enable_ddl_logging=FALSE; Which statement is true?

Options

ANone of the data definition language (DDL) statements are logged in the trace file.
BOnly DDL commands that resulted in errors are logged in the alert log file.
CA new log.xml file that contains the DDL statements is created, and the DDL command details are
DOnly DDL commands that resulted in the creation of new database files are logged.

How the community answered

(47 responses)

A
87% (41)
B
4% (2)
C
6% (3)
D
2% (1)

Explanation

ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL alert 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.

Topics

#DDL logging#enable_ddl_logging#alert log#trace file

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice