单项选择题
You received the following error:
ORA-01578: ORACLE data block corrupted
(file # %s, block # %s)
Which file will you check to view additional information regarding the cause of this error?()
A.the alert log file and the trace files
B. the redo log files
C. the control file
D. the change tracking file
相关考题
-
单项选择题
YouwanttorebuildafreelistinthefreelistsoftheEMPLOYEEtableintheScottschema.Whichpackagewillyouusetoaccomplishthis?()
A. DBMS_REPAIR
B. DBMS_SCHDULER
C. DBMS_STATS
D. DBMS_RESOURCE_MANAGER -
单项选择题
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 -
单项选择题
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility?()
A. The block change tracking feature must be enabled.
B. OMF must be configured on your database.
C. The database must be in ARCHIVELOG mode.
D. A USERID must be supplied.
