Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery？（）A.BlockMediaRecoverymustbeusedwithRMAN.B.Youmustperformcompleterecoveryofindividualblocks.C.YoumusthaveafullRMANbackup，notanincrementalbackup.D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.
Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery？（）
A.BlockMediaRecoverymustbeusedwithRMAN.
B.Youmustperformcompleterecoveryofindividualblocks.
C.YoumusthaveafullRMANbackup，notanincrementalbackup.
D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.
相关考题：
Whenyoutrytoopenyourdatabase,youreceivethefollowingerror:ORA－00205:errorinidentifyingcontrolfileWherewouldyoufindthedetailsrequiredtoresolvethiserror?() A.audittrailB.alertlogfileC.usertracefileD.onlinetracefileE.backgroundtracefileF.operatingsystemeventviewer
YouissuedthefollowingcommandtoanalyzetheSCOTT.EMPtableforblockcorruption：ANALYZETABLESCOTT.EMPVALIDATESTRUCTURE；Youreceivedthefollowingerror：ORA-01578：ORACLEdatablockcorrupted（file%s，block%s）Howwillyouresolvetheblockcorruptionproblem？（）A.byusingtheDBMS_REPAIRpackageB.byusingtheDB_BLOCK_CHECKINGparameterC.byusingtheDBVERIFYutilityD.willnotbecompletelyresolveduntilthehardwarefaultiscorrected
Youreceivedthefollowingerror:ORA－01578:ORACLEdatablockcorrupted(file%s,block%s)Whichfilewillyouchecktoviewadditionalinformationregardingthecauseofthiserror?() A.thealertlogfileandthetracefilesB.theredologfilesC.thecontrolfileD.thechangetrackingfile
Youissuethefollowingstatement：SQLSELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）A.byusingtheDBMS_REPAIRpackageB.byusingtheDBVERIFYutilityC.byusingBlockMediaRecoveryD.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand
Youreceivethefollowingerror:ORA－19804:cannotreclaimnnnnnbytesdiskspacefrommmmmmlimitIdentifythereasonforreceivingtheaboveerrormessage?() A.Thesortareaisverysmall.B.ThereisnomorespaceintheUndotablespace.C.Theflashrecoveryareaisfull.D.Theonlineredologfileisfull.
Identifythetwosituationsinwhichthealertlogfileisupdatedwithdetails.() A.RunningaqueryonatablereturnsORA-600：InternalError.B.InsertingavalueinatablereturnsORA-01722：invalidnumber.C.CreatingatablereturnsORA-00955：nameisalreadyusedbyanexistingobject.D.InsertingavalueinatablereturnsORA-00001：uniqueconstraint（SYS.PK_TECHP）violated.E.RebuildinganindexusingALTERINDEX...REBUILDfailswithanerrorORA-01578：ORACLEdatablockcorrupted（file#14，block#50）.
YouarepartoftheDBAteamworkingforaGRANTSYSDBATOjohn；However，youreceivethefollowingerror：ORA-01996：GRANTfailed：passwordfile’c：\oracle\ora9i\dbs\testdb.pwd’isfullWhichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers？（）
Identify two situations in which the alert log file is updated.() A. Running a query on a table returns ORA-600: Internal Error.B. Inserting a value into a table returns ORA-01722: invalid number.C. Creating a table returns ORA-00955: name us already in used by an existing objects.D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
YouworkasadatabaseadministratoratCertkiller&ensp YouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：01578：ORACLEdatablockcorrupted（file#5，block#51）ORA-01110：datafile5：’/u01/app/oracle/oradata/orcl/example01.dbf’Youneedtorectifythecorruptionwhileensuringthefollowing：Thedatafileshouldremainonline.Themeantimetorecover（MTTR）shouldbeminimal.Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.Whichoptionwouldyouchoose？（）