BCD
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
The values of all initialization parameters that had nondefault values at the time the database and instance start
the correct answers are BCD
A is not correct because it includes messages Administrative operations, such as starting up or shutting down the database, recovering
the database, creating or dropping a tablespace, and others. But it does not report all DDLs
Provided answer are corrects:
The alert log is a chronological log of messages and errors, and includes the following items:
All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
Messages and errors relating to the functions of shared server and dispatcher processes
Errors occurring during the automatic refresh of a materialized view
The values of all initialization parameters that had nondefault values at the time the database and instance start.
In item 8.1.1.1 (About Monitoring Errors with Trace Files and the Alert Log) in the version 19c documentation, the following information is included:
The alert log is a chronological log of messages and errors, and includes the following items:
All internal errors (ORA-00600), block corruption errors (ORA-01578), and deadlock errors (ORA-00060) that occur
Administrative operations, such as some CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
Messages and errors relating to the functions of shared server and dispatcher processes
Errors occurring during the automatic refresh of a materialized view
The values of all initialization parameters that had nondefault values at the time the database and instance start
Therefore, I understand that there are four correct options in this item: ABCD
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
C and D are correct
All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
The values of all initialization parameters that had nondefault values at the time the database and instance start
A - Incorrect
The DDL log is stored in the log/ddl subdirectory of the ADR home
11g : DDL go both log.xml & alert.log
12c : DDL only go to log.xml
"The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL statements are not included in the DDL log, but they are included in the alert log."
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/ENABLE_DDL_LOGGING.html#GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Mandar79
Highly Voted 3 years, 10 months agoEkos
3 years, 7 months agoOracle2020
Most Recent 3 months, 1 week agoauwia
1 year agoFrozencc
1 year agoflaviogcmelo
3 years, 2 months agoauwia
1 year agos_sani
3 years, 9 months agokemsalim
8 months, 2 weeks agoNowOrNever
3 years, 9 months agoMandar79
3 years, 10 months ago[Removed]
10 months ago