In which of the scenario will the DBA perform recovery? (Choose all that apply.)

The alert log is a plain-text diagnostic file outside the database structure used for logging events and errors; its corruption has no impact on database data and does not require any form of database recovery.

A dropped tablespace permanently removes the tablespace and its associated datafiles from the database; the DBA must restore the datafiles from a backup and perform media recovery to bring them to a consistent state.

Oracle redo log groups are designed with multiple members for redundancy; if one member is corrupted but other members in the same group are intact, Oracle continues operating normally without requiring DBA recovery actions.

When a user disconnects abnormally, the PMON (Process Monitor) background process automatically detects the orphaned process, releases its resources, and rolls back any uncommitted transactions without requiring DBA intervention.

Corruption of the hard disk holding datafiles results in physical media loss that Oracle cannot recover automatically; the DBA must restore the affected datafiles from backup and apply archived redo logs to recover to the point of failure.