Oracle
1Z0-060 · Question #130
1Z0-060 Question #130: Real Exam Question with Answer & Explanation
The correct answer is C: All DDL commands are logged in a different log file that contains DDL statements and their execution dates.. DLL command are loged in separate log files There are two DDL logs that contain the same information. One is an XML file, and the other is a text file. The DDL log is stored in the log/ddl subdirectory of the ADR home.
Question
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?
Options
- AOnly the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
- BAll DDL commands are logged in the alert log file.
- CAll DDL commands are logged in a different log file that contains DDL statements and their execution dates.
- DOnly DDL commands that resulted in the creation of new segments are logged.
- EAll DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository
Explanation
DLL command are loged in separate log files There are two DDL logs that contain the same information. One is an XML file, and the other is a text file. The DDL log is stored in the log/ddl subdirectory of the ADR home.
Community Discussion
No community discussion yet for this question.