1Z0-062 · Question #323
Examine the command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true in this scenario? (Choose two.)
The correct answer is 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. This question examines the logging behavior of Data Definition Language (DDL) commands when ENABLE_DDL_LOGGING is enabled.
Question
Examine the command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true in this scenario? (Choose two.)
Options
- AAll data definition language (DDL) commands ae 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.
How the community answered
(56 responses)- A4% (2)
- B14% (8)
- C75% (42)
- E7% (4)
Why each option
This question examines the logging behavior of Data Definition Language (DDL) commands when `ENABLE_DDL_LOGGING` is enabled.
DDL commands, when `ENABLE_DDL_LOGGING` is true, are primarily logged to a specific DDL log within ADR, not the alert log file.
Only a subset of DDL commands is logged, not all, and they are written to a structured log (often XML) within ADR, not just a generic text file.
When `ENABLE_DDL_LOGGING` is set to TRUE, Oracle writes a subset of executed DDL statements, not all, into a structured log file within the Automatic Diagnostic Repository (ADR) home, typically in XML format for easy parsing and analysis.
With `ENABLE_DDL_LOGGING=TRUE`, a subset of DDL statements is indeed written to a dedicated DDL log file within the Automatic Diagnostic Repository (ADR) home, providing a record of schema changes.
DDL commands are directed to a dedicated DDL log within ADR, not a general trace file, when `ENABLE_DDL_LOGGING` is enabled.
Concept tested: Oracle DDL logging and Automatic Diagnostic Repository
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-SYSTEM.html#GUID-26C78625-780C-4A73-A656-A8334469213B
Topics
Community Discussion
No community discussion yet for this question.