网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
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.

参考答案

更多 “ 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. ” 相关考题
考题 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.
查看答案
考题 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
查看答案
考题 WhichstatementwillNOTcreateatablespace?() A.CREATETABLESPACEDATA1DATAFILE’+grp1/abc（datafile）’；B.CREATETABLESPACEDATA1DATAFILE’+grp1’；C.CREATETABLESPACEDATA1DATAFILE’+data1（tempfile）’；D.CREATETABLESPACEDATA1DATAFILE’+grp1.256.34359’；
查看答案
考题 Youexecutedthefollowingcode:BACKUPVALIDATEDATABASE;BLOCKRECOVERCORRUPTIONLIST;Whatwillbetheresultofexecutingtheabovecode?() A.ThecodewillrunabackupvalidationtopopulatetheV$BACKUP_CORRUPTIONviewandrepaircorruptblocks，ifany，recordedintheview.B.ThecodewillrunabackupvalidatetopopulatetheV$COPY_CORRUPTIONviewandthenrepairanycorruptblocksrecordedintheview.C.ThecodewillrunsabackupvalidatetopopulatetheV$DATABASE_BLOCK_CORRUPTIONviewandthenrepaircorruptblocks，ifany，recordedintheview.D.ThecodewillrunabackupvalidatetopopulatetheRC_BACKUP_CORRUPTIONviewandthenrepaircorruptblocks，ifany，recordedintheview.
查看答案
考题 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
查看答案
考题 4.检索和名叫SCOTT的员工相同工资的员工信息，但不显示SCOTT。显示字段：员工号、员工名、工资。
查看答案
考题 AT供电方式，Scott接线变压器馈线出口侧不需要加装AT。
查看答案
考题 假设用户SCOTT以管理员身份登录，需授予用户Lisa对SCOTT用户模式下的EMP表 进行查询（SELECT)的权限，请写出该命令 。
查看答案
热门标签
最新试卷