此题为判断题(对,错)。
第1题:
A.award
B.reward
C.price
D.prize
第2题:
Youwanttoenabletheuser,Scott,tochangetotheGRP1consumergroupbyissuingthefollowingcode:SQL>EXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP(’SCOTT’,’GRP1’,FALSE);Howwillyougranttheswitchprivilegetotheuser,Scott?()
A.byusingtheDBMS_SESSIONpackage
B.bygrantingtheDBArole
C.byusingtheDBMS_RESOURCE_MANAGERpackage
D.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage
第3题:
A.Theuser,Scott,isdropped,alltheobjectsinScott’sschemaareplacedintheRecycleBin,andtheobjectsthatarealreadyintheRecycleBinaredropped.
B.Theuser,Scott,isdropped,alltheobjectsinScott’sschemaareplacedintheRecycleBin,andalltheobjectsintheRecycleBin,belongingtotheuserScott,arenotdropped.
C.Theuser,Scott,isdropped,alltheobjectsintheScott’sschemaarenotplacedintheRecycleBin,andtheobjectsintheRecycleBin,belongingtotheuser,Scott,arenotdropped.
D.Theuser,Scott,isdropped,alltheobjectsinScott’sschemaarenotplacedintheRecycleBin,andtheobjectsintheRecycleBinaredropped.
第4题:
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.
第5题:
A.Theswitchprivilegewillbegrantedtotheuser,Scott,forchangingtheconsumergrouptoGRP1.
B.Theswitchprivilegewillbegrantedtotheuser,Scott,forchangingtheconsumergroupfromGRP1toanyothergroup.
C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.
D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser,Scott.
第6题:
The passage is probably followed by a concluding paragraph about .
A. Zelda’s personal life
B. Zelda’s illness and treatment
C. Fitzgerald’s friendship with Graham
D. Fitzgerald’s contributions to the literary world