网友您好, 请在下方输入框内输入要搜索的题目:
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.
参考答案