A.Alldataalongwiththetablestructureisdeleted
B.Thependingtransactioninthesessioniscommitted
C.Allindexesonthetablewillremainbuttheyareinvalidated
D.Allviewsandsynonymswillremainbuttheyareinvalidated
E.Alldatainthetablearedeletedbutthetablestructurewillremain
第1题
A.Makesureyourreplaydatabasehasthesamestructureasthecapturedatabase,exceptwithoutdata.
B.Makesurethereplayandcapturedatabasesaresimilarindatacontent.
C.Performacleanshutdownandrestartofthecapturedatabasebeforebeginningaworkloadcapture.
D.StartthecapturedatabaseinUNRESTRICTEDmode,thenstartthecapture.
E.Defineinclusionandexclusionfilters.
第2题
A.TheCPUcannotbeassignedtothemembersoftheSYS_GROUPgroup.
B.ThemembersoftheOTHER_GROUPSgroupwillalwaysbeassigned100percentCPU.
C.ThemembersoftheOTHER_GROUPSgroupwillneverbeassigned100percentCPU.
D.ThemembersoftheOTHER_GROUPSgroupwillbeassigned100percentCPUiftheCPUisnotassignedtothemembersoftheSYS_GROUPgroupandthePAYROLL,SALES,andMARKETINGgroups.
第3题
A. SET_JOB_ARGUMENT_VALUE
B. SET_JOB_VALUE_ANYDATA
C. SET_JOB_ANYDATA_VALUE
D. SET_SPECIAL_JOB_VALUE
E. SET_JOB_ANYTYPE_VALUE
第4题
agedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement:
SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE
(PLAN=>’SALES_PLAN’,
GROUP_OR_SUBPLAN=>’MANAGERS’,
CPU_P1=>100,CPU_P2=>0,
SWITCH_GROUP=>’CLERKS’,
SWITCH_TIME_IN_CALL=>600);
Auser,SCOTT,whoisassignedtotheMANAGERSgroup,startsadatabasesessionandexecutesaqueryonthedatabase.Whatistheoutcomeifthequerytakesapproximately15minutestocomplete?()
第5题
A. ENABLE启用
B. ENABLE_PROGRAM
C. VALIDATE_PROGRAM
D. SET_ATTRIBUTE设置属性
E. SET_ENABLED
第6题
resourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement:SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’;Whatwillbetheoutcomeofthisstatement?()
A.ThestatementwilldeactivateDAY_PLAN.
B.ThestatementwillactivateDAY_PLANasthetopplan.
C.ThestatementwillactivateMANAGERS_PLANasthetopplan.
D.ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.
第7题
A.Itcanbeusedtojoinamaximumofthreetables
B.ItcanbeusedtorestrictthenumberofcolumnsusedinaNATURALjoin
C.Itcanbeusedtoaccessdatafromtablesthroughequijoinsaswellasnonequijoins
D.Itcanbeusedtojointablesthathavecolumnswiththesamenameandcompatibledatatypes
第8题
sourceconsumergroup,DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement:
SQL>EXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(PLAN=>’DSS_PLAN’,
GROUP_OR_SUBPLAN=>’DSS_USERS’,
NEW_CPU_P1=>80,
NEW_SWITCH_GROUP=>’CANCEL_SQL’,
NEW_SWITCH_ESTIMATE=>TRUE,
NEW_SWITCH_TIME=>600);
Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds?()
第9题
A. FREQ
B. BYHOUR
C. RUNDATE
D. INTERVAL
E. BYMINUTE
第10题
A. Database must be running in archivelog mode.
B. Automatic undo management must be enabled.
C. Undo retention guarantee must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!