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