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

题目内容 (请给出正确答案)

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?()

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B. ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG


参考答案

更多 “ Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?()A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG ” 相关考题
考题 You look(). What () you () ? A、tire, did…doB、tiring, have…doneC、tired, do…doD、tired, have…been doing

考题 How long() you() a member of the club? A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

考题 Where ________ you ________?A.are/beB.have/beC.is/beD.have/been

考题 What's ( )job? Are ( ) British?A. your, yourB. you, yourC. your, you

考题 Merry Christmas, George! Here is a card for ________, with ________ best withes. A.you…yourB.you…ourC.us…ourD.us…your

考题 Youhavethefollowingonlineredologconfiguration:GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles?()A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1;B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1;C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2;D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2;E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3;F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3;

考题 Yourdatabaseisinmanualarchivemode.Youronlineredologgroupsareconfiguredasfollows:YoudiscoverthatDISK3hasencounteredamediafailurethathasresultedinalossofallthemultiplexedcopiesofonlineredologfiles.YoudecidetodeletetheREDO01C.LOG,REDO02C.LOG,andREDO3C.LOGfilestopreventtheLGWRbackgroundprocessfromattemptingtoaccessthesefiles.WhenyouquerytheV$LOGdynamicview,youreceivethefollowingoutput:Whichsequenceofstatementsshouldyouusetodropthemissingonlineredologfilesfromthedatabase?()1.ALTERDATABASEDROPLOGFILEMEMBER’E:\REDO01C.LOG’;2.ALTERSYSTEMSWITCHLOGFILE;3.ALTERDATABASEDROPLOGFILEMEMBER’E:\REDO03C.LOG’;4.ALTERSYSTEMARCHIVELOGGROUP3;5.ALTERDATABASEDROPLOGFILEMEMBER’E:\REDO02C.LOG’;6.ALTERSYSTEMARCHIVELOGGROUP1;

考题 WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?() A.TARGET_REDO_BLKSB.FAST_START_IO_TARGETC.LOG_CHECKPOINT_TIMEOUTD.RECOVERY_ESTIMATED_IOSE.LOG_FILE_SIZE_REDO_BLKSF.LOG_CHECKPOINT_INTERVAL

考题 ( ) – Is Miss White __________ English teacher, Maria?– No, she teaches __________ geography.A.your;myB.you;mineC.you;usD.your;us

考题 You look() What()you()?Atire;did;doBtiring;have;doneCtired;do;doDtired;have;been doing