Oracle OCP Certification Exam Bank Analysis 052-4

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