OCP-1Z0-052-V8.02-157题
来源:互联网 发布:java io nio 面试 编辑:程序博客网 时间:2024/04/29 00:36
157. Examine the commands executed in the following sequence:
1: SQL> CREATE ROLE mgrrole;
2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;
3: SQL> GRANT select,update ON sh.sales TO mgrrole;
4: SQL> CREATE ROLE ceo IDENTIFIED BY boss;
5: SQL> GRANT mgrrole,drop any table,create any directory TO ceo;
6: SQL> GRANT ceo TO mgrrole;
Which statement is true about the above commands?
A.The commands execute successfully.
B.Command 6 produces an error because of circular role grant.
C.Command 5 produces an error because a rolecannot be granted to another role.
D.Command 3 produces an error because the MGRROLE role already contains system privileges.
.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other
users.
Answer: B
现象重现:
1、
- OCP-1Z0-052-V8.02-157题
- OCP-1Z0-052-V8.02-1题
- OCP-1Z0-052-V8.02-91题
- OCP-1Z0-052-V8.02-92题
- OCP-1Z0-052-V8.02-80题
- OCP-1Z0-052-V8.02-81题
- OCP-1Z0-052-V8.02-82题
- OCP-1Z0-052-V8.02-79题
- OCP-1Z0-052-V8.02-77题
- OCP-1Z0-052-V8.02-23题
- OCP-1Z0-052-V8.02-72题
- OCP-1Z0-052-V8.02-156题
- OCP-1Z0-052-V8.02-155题
- OCP-1Z0-052-V8.02-29题
- OCP-1Z0-052-V8.02-110题
- OCP-1Z0-052-V8.02-165题
- OCP-1Z0-052-V8.02-171题
- OCP-1Z0-052-V8.02-170题
- HTML5画布上拖动和kineticjs掉落线,这个需要认真看哦!
- Dynamics CRM 2011 编程系列:自定义工作流
- watir和Selenium有必要学下
- ad噶地方很多富豪大富豪
- 做才能再次vmnwfgj
- OCP-1Z0-052-V8.02-157题
- 屏幕适配
- 直接拿来用!最火的Android开源项目(一)
- opencv 边缘检测,角点检测
- Leetcode Symmetric Tree
- 改变Apache端口等配置修改方法
- .Net时间计算函数,统计某一天是一年的第几周,这一周从哪天开始到哪天结束
- vim 中文文档
- 【机房系统知识小结点系列】之DataGridView控件导出为Excel