网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

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？（）
查看答案
热门标签
最新试卷