You issue the following statement: SQL> SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE; You receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()
- A by using the DBMS_REPAIR package
- B by using the DBVERIFY utility
- C by using Block Media Recovery
- D by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command