A.absorbB.attractC.mobilizeD.channel
A.absorb
B.attract
C.mobilize
D.channel
A.absorb
B.attract
C.mobilize
D.channel
第1题
A.Thedatabaseinstanceaborts.
B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.
C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.
D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
第2题
A.Undodataisretaineduntilthenextfulldatabasebackup.
B.Nocommittedundodatawillbeoverwrittenfor10minutes.
C.Committedundodatawillbekeptforeverifnotoverwrittenwithin600seconds.
D.Guaranteesthatrequestedundoinformationareavailableuntiltheinstanceisshutdown.
第3题
A.shutdownandrestarttheinstance
B.addnewtempfilestothetemporarytablespacesafterrecovery
C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption
D.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode
第4题
A.Thedatabaseinstanceaborts.
B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.
C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.
D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.
第5题
A.Theoptimizerstatisticsarecollectedautomatically.
B.Onlythetimedoperatingsystem(OS)statisticsandplanexecutionstatisticsarecollected.
C.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.
D.ThesnapshotsfortheAutomaticWorkloadRepository(AWR)arenotgeneratedautomatically.
E.SnapshotscannotbecollectedmanuallybyusingDBMS_WORKLOAD_REPOSITORYPACKAGE.
第6题
A.Theoptimizerstatisticsarecollectedautomatically.
B.Onlythetimedoperatingsystem(OS)statisticsandplanexecutionstatisticsarecollected.
C.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.
D.ThesnapshotsfortheAutomaticWorkloadRepository(AWR)arenotgeneratedautomatically.
E.SnapshotscannotbecollectedmanuallybyusingDBMS_WORKLOAD_REPOSITORYPACKAGE.
第7题
A.importthedatabasefromthelastexport
B.restoreallthemembersinthegroupfromthelastbackup
C.dropthelostmemberfromthedatabaseandthenaddanewmembertothegroup
D.restoreallthedatabasefilesfromthebackupandthenperformacompleterecovery
E.restoreallthedatabasefilesfromthebackupandthenperformanincompleterecovery
第8题
A.7,2,3,1,4,6,5
B.7,1,3,2,6,5,4
C.2,1,7,6,3,5,4
D.2,7,3,5,1,6,4
第9题
A.flashbackthedatabase
B.performpoint-in-timerecovery
C.performafulldatabaserecovery
D.dropandre-createthetablespace
E.useRecoveryManager(RMAN)torecoverthedatabase
第10题
A.shutdownandrestarttheinstance
B.addnewtempfilestothetemporarytablespacesafterrecovery
C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption
D.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!