Oracle Exam 1Z0-062 Topic 9 Question 41 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 41
Topic #: 9

Examine the command:

SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

Which two statements are true in this scenario? (Choose two.)

AAll data definition language (DDL) commands are logged in to the alert log file.

BAll DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.

CA subset of executed DDL statements is written into an XML file in ADR home.

DA subset of executed DDL statements is written to the DDL log in ADR home.

EAll DDL commands are logged in to a trace file in ADR home.

Show Suggested Answer

Suggested Answer: C, D

by Lisha at May 05, 2022, 06:09 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!