In which of the scenario will the DBA perform recovery? (Choose all that apply.)
A.
A database user terminates the session abnormally
B.
The hard disk on which the data files is stored is corrupted
C.
The alert log file is corrupted
D.
A tablespace is accidentally dropped
E.
One of the redo log members is corrupted
anything related to datafile corruption or dropping,DBA will have to perform recovery.
1.Tablespace consists of datafiles,if the tablespace is dropped the datafiles will get dropped,so recovery is needed as data is available in datafiles.
2.Hard disk on which datafiles are stored is corrupted.
i.e. this will in turn affect the datafiles.
B & D