QUESTION 4
In which of the scenario would the DBA perform recovery? (Choose all, apply.)
A. The alert log file is corrupted
B. A Tablespace is accidentally dropped
C. One of the redo log members is corrupted
D. A database user terminates the session abnormally
E. The hard disk on which the data files are stored is corrupted
Correct Answer:be
Explanation/reference: DBAs typically perform recovery operations when media corruption occurs in the database. A: Error, alert log corruption The database does not lose data and does not require recovery. B: correctly, the table space is renamed in the operating system and needs to be restored, the database cannot find the data file corresponding to the tablespace. C: Error, loss of redo member, no loss of data, no need to perform recovery operation. D: Error, session abort does not lose data, no recovery is required, the database frees resources that the exception session occupies. E: Correct, the disk corruption causes the data file on the disk to become corrupted and need to perform a recovery operation. |
for more questions, please follow: http://ke.qq.com/cgi-bin/courseDetail?course_id=36323
Oracle OCP Certification Exam Bank Analysis 052-4