itgle.com

YousettheundopoolresourceplandirectivefortheconsumergroupnamedDSS_USERSthatisassignedtotheDAY_SHIFTplan.Thedatabaseusers,SCOTTandBLAKE,belongtotheDSS_USERSresourcegroup.Theuser,SCOTT,initiatesadatabasesessionandexecutesabatchoperationthatinsertsmillionsof

题目

YousettheundopoolresourceplandirectivefortheconsumergroupnamedDSS_USERSthatisassignedtotheDAY_SHIFTplan.Thedatabaseusers,SCOTTandBLAKE,belongtotheDSS_USERSresourcegroup.Theuser,SCOTT,initiatesadatabasesessionandexecutesabatchoperationthatinsertsmillionsofrowsintotheHISTORYtable.WhichtwooptionsaretrueifthetotalundospaceallocatedtotheDSS_USERSgroupexceedsthevaluespecifiedintheundopoolresourceplandirective?()

A.Thebatchoperationstartedbytheuser,SCOTT,terminateswithanerror.

B.Thebatchoperationstartedbytheuser,SCOTT,hangsandyouarerequiredtoincreasetheundopoolresourceplandirective.

C.Thebatchoperationstartedbytheuser,SCOTT,runsuninterruptedbecausethedatabaseusestheSYSTEMtablespacefortheundooperation.

D.Theuser,BLAKE,cannotstartatransactionthatusesanyDMLoperationsuntilyouincreasethevalueoftheundopoolresourceplandirective.

E.TheuserBLAKEcanstartatransactionthatusesanyDMLoperationsafterthebatchoperationstartedbytheuser,SCOTT,terminateswithanerror.


相似考题
参考答案和解析
参考答案:A, D