nerdexam
Oracle

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.

Implementing Oracle Database Auditing

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)
  • A
    4% (2)
  • B
    14% (8)
  • C
    75% (42)
  • E
    7% (4)

Why each option

This question examines the logging behavior of Data Definition Language (DDL) commands when `ENABLE_DDL_LOGGING` is enabled.

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

DDL commands, when `ENABLE_DDL_LOGGING` is true, are primarily logged to a specific DDL log within ADR, not the alert log file.

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

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.

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

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.

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

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.

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

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

#DDL Logging#ADR#System Parameters

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice