Which statement is true?

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

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

A.
Only DDL commands that resulted in the creation of new database files are logged.

B.
None of the data definition language (DDL) statements are logged in the trace file.

C.
Only DDL commands that resulted in errors are logged in the alert log file.

D.
A new log.xml file that contains the DDL statements is created, and the DDL command
details are removed from the alert log file.



Leave a Reply 1

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


Patty

Patty

B.
If you set the enable_ddl_logging parameter to true, the instance will record the DDL changes in the log.xml file. If you don’t set this parameter to true, Oracle won’t record these changes to the log.xml or the alert log.