Which three activities are recorded in the database alert log? (Choose three.)
Which three activities are recorded in the database alert log? (Choose three.)
The database alert log records various significant activities related to the database. These include the values of all initialization parameters that have non-default values at the time the database and instance start, block corruption errors (ORA-1578), and deadlock errors (ORA-60). This information is crucial for database administrators to monitor and troubleshoot issues in the database environment.
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
i agree
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
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.
BCD are correct
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
A is wrong because only CREATE. ALTER and DROP are tracked, RENAME and TRUNCATE not!. DDL = CREATE, ALTER, DROP, RENAME AND TRUNCATE.
CDE https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11242
E is wrong
E is trully wrong because when you open that alert log u can't find it in alert log for sure