Oracle
1Z0-043 · Question #64
1Z0-043 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
You work as a database administrator at certkiller.com. Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.employees table, you receive the following error message: 01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5: '/u01/app/oracle/oradata/orcl/example01.dbf' You need to rectify the corruption while ensuring the following: - The data file should remain online. - The mean time to recover (MTTR) should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose?
Options
- Aflash back the corrupted blocks
- Buse the DBMS_REPAIR package
- Cuse the RMAN TSPITR command
- Duse the RMAN BLOCKRECOVER command
- Euse the RESTORE DATABASEand RECOVER DATABASE commands
- Finvestigate the time at which the corruption occurred and perform a point-in-time recovery
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.