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.
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)- A8% (1)
- B17% (2)
- D67% (8)
- F8% (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.
Not all DDL statements are written to the control file; only those affecting the physical database structure are.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.