nerdexam
Oracle

1Z0-062 · Question #369

Examine this command: SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true? (Choose two.)

The correct answer is D. Some data definition language (DDL) statements are written to the control file E. Some DDL statements are written to a text file in the ADR home. After enabling DDL logging, DDLs affecting database structure continue to be recorded in the control file, and some DDLs are logged to the alert log, which is a text file within the ADR home.

Implementing Oracle Database Auditing

Question

Examine this command:

SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true? (Choose two.)

Options

  • AAll data definition language (DDL) statements are written to the control file
  • BSome DDL statements are written to an XML file in the ADR home
  • CAll DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
  • DSome data definition language (DDL) statements are written to the control file
  • ESome DDL statements are written to a text file in the ADR home
  • FThe Alert Log still contains some DDL statements

How the community answered

(12 responses)
  • A
    8% (1)
  • B
    17% (2)
  • D
    67% (8)
  • F
    8% (1)

Why each option

After enabling DDL logging, DDLs affecting database structure continue to be recorded in the control file, and some DDLs are logged to the alert log, which is a text file within the ADR home.

AAll data definition language (DDL) statements are written to the control file

Not all DDL statements are written to the control file; only those affecting the physical database structure are.

BSome DDL statements are written to an XML file in the ADR home

While ENABLE_DDL_LOGGING=TRUE causes DDLs to be written to XML files in the ADR home, this is not among the designated correct answers, focusing instead on other DDL logging locations.

CAll DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home

Not all DDL statements are logged to a single text file in the ADR home; instead, comprehensive DDL logging goes to XML files, and the alert log is one text file containing some DDLs.

DSome data definition language (DDL) statements are written to the control fileCorrect

Oracle logs DDL statements that modify the physical database structure, such as creating or altering tablespaces and data files, to the control file for recovery and consistency purposes.

ESome DDL statements are written to a text file in the ADR homeCorrect

The alert log, which is a plain text file located in the Automatic Diagnostic Repository (ADR) home, records various significant database events and system messages, including some DDL statements.

FThe Alert Log still contains some DDL statements

This statement is functionally equivalent to E, as the alert log is the primary text file in the ADR home that contains DDL statements, but only two choices are correct.

Concept tested: Oracle DDL logging mechanisms and Automatic Diagnostic Repository (ADR)

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/monitoring-database-activity.html#GUID-7712CC2A-07D9-4DA3-BD28-A45A95210103

Topics

#DDL logging#ADR#Automatic Diagnostic Repository#alert log

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice