Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQLEXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）A.byusingtheDBMS_SESSIONpackageB.bygrantingtheDBAroleC.byusingtheDBMS_RESOURCE_MANAGERpackageD.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage
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
相关考题：
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.
Youissuethefollowingcode:EXECDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(’SCOTT’’GRP1’,TRUE);Whatwillbetheresultofexecutingtheabovecode?() A.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergrouptoGRP1.B.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergroupfromGRP1toanyothergroup.C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser，Scott.
WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE;command?() 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.
YouaremaintainingyourdatabaseinARCHIVELOGmode.Animportanttable，SCOTT.EMPLOYEE，isdroppedandpurgedfromtheRecycleBinonMondayat2：00P.M.YoudonotuseRMANtoperformbackups.Youperformedthelastfulluser-managedbackupat9：00P.M.onSunday.Howwillyourecoverthedroppedtable，SCOTT.EMPLOYEE？（）A.byusingtheFlashbackTablefeatureB.byusingtheFlashbackDatabasefeatureC.byperformingincompleterecoveryusingRMANutilityD.byperformingincompleterecoveryusinguser-managedrecovery
在oracle数据库下,在启用审计的数据库上执行下面的命令SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;有关此命令的影响描述正确的是?() A.每一个会话drop属于scott用户的表成功就会产生一条审计记录B.凡是每一个scott用户会话成功droptable操作，就会存在一条审计记录C.同一个scott会话中，drop一张或多张表成功就会产生一条审计记录D.scott用户授权给其它用户droptable权限时就会生成一条审计记录
根据提供的信息和语言素材设计教学方案。用英文作答。设计任务：请阅读下面学生信息和语言素材，设计一节英语听说课的教学方案。教案没有固定格式，但须包含下列要点：?teaching objectivesteaching contentskey and difficult pointsmajor steps and time allocationactivities and justification教学时间：45分钟?学生概况：某城镇普通中学七年级(初中一年级)学生，班级人数40人，多数学生已经达到?《义务教育英语课程标准(2011年版)》二级水平，学生课堂参与积极性一般。语言素材：?Interviewer: Scott has an interesting job. He works at a radio station. Scott, what time is your radio show?Scott: From twelve o'clock at night to six o'clock in the morning.Interviewer:. What time do you usually get up?Scott: At eight thirty at night. Then ! eat breakfast at nine.Interviewer: That's a funny time for breakfast!Scott: Yeah. After that, I usually exercise at about ten twenty.Interviewer: When do you go to work?Scott: At eleven o'clock I so I'm never late for work.
假设用户SCOTT以管理员身份登录，需授予用户Lisa对SCOTT用户模式下的EMP表 进行查询（SELECT)的权限，请写出该命令 。