exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 91 discussion

Actual exam question from Oracle's 1z0-082
Question #: 91
Topic #: 1
[All 1z0-082 Questions]

Which three activities are recorded in the database alert log? (Choose three.)

  • A. Data Definition Language (DDL) statements
  • B. non-default database parameters
  • C. block corruption errors
  • D. deadlock errors
  • E. session logins and logouts
Show Suggested Answer Hide Answer
Suggested Answer: BCD 🗳️
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Mandar79
Highly Voted 3 years, 10 months ago
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
upvoted 13 times
Ekos
3 years, 7 months ago
i agree
upvoted 2 times
...
...
Oracle2020
Most Recent 3 months, 1 week ago
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
upvoted 1 times
...
auwia
1 year ago
Selected Answer: BCD
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.
upvoted 1 times
...
Frozencc
1 year ago
Selected Answer: BCD
BCD are correct
upvoted 1 times
...
flaviogcmelo
3 years, 2 months ago
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
upvoted 1 times
auwia
1 year ago
A is wrong because only CREATE. ALTER and DROP are tracked, RENAME and TRUNCATE not!. DDL = CREATE, ALTER, DROP, RENAME AND TRUNCATE.
upvoted 3 times
...
...
s_sani
3 years, 9 months ago
CDE https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11242
upvoted 1 times
kemsalim
8 months, 2 weeks ago
E is trully wrong because when you open that alert log u can't find it in alert log for sure
upvoted 1 times
...
NowOrNever
3 years, 9 months ago
E is wrong
upvoted 2 times
...
...
Mandar79
3 years, 10 months ago
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
upvoted 2 times
[Removed]
10 months ago
"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
...
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago