OCP-1Z0-新051-61题版本-56
来源:互联网 发布:linux ssh修改文件内容 编辑:程序博客网 时间:2024/05/19 17:27
QUESTION NO: 56
Examine these statements:
CREATE ROLE registrar;
GRANT UPDATE ON student_grades TO registrar;
GRANT registrar to user1, user2, user3;
What does this set of SQL statements do?
A. The set of statements contains an error and does not work.
B. It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES
object to the role, and gives the REGISTRAR role to three users.
C. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
object to the role, and gives the REGISTRAR role to three users.
D. It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
object to the role, and creates three users with the role.
E. It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the
REGISTRAR role to the STUDENT_GRADES object.
F. It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and
gives the UPDATE role to the registrar.
Answer: C
Explanation: the statement will create a role call REGISTRAR, grant UPDATE on student_grades
to registrar, grant the role to user1,user2 and user3.
Incorrect answer:
Oracle 1z0-051 Exam
"Pass Any Exam. Any Time." - 100% Pass Guarantee 47
Athe statement does not contain error
Bthere is no MODIFY privilege
Dstatement does not create 3 users with the role
Eprivilege is grant to role then grant to user
Fprivilege is grant to role then grant to user
- OCP-1Z0-新051-61题版本-56
- OCP-1Z0-新051-61题版本-61
- OCP-1Z0-新051-61题版本-1
- OCP-1Z0-新051-61题版本-2
- OCP-1Z0-新051-61题版本-3
- OCP-1Z0-新051-61题版本-4
- OCP-1Z0-新051-61题版本-5
- OCP-1Z0-新051-61题版本-6
- OCP-1Z0-新051-61题版本-7
- OCP-1Z0-新051-61题版本-8
- OCP-1Z0-新051-61题版本-9
- OCP-1Z0-新051-61题版本-10
- OCP-1Z0-新051-61题版本-11
- OCP-1Z0-新051-61题版本-12
- OCP-1Z0-新051-61题版本-13
- OCP-1Z0-新051-61题版本-14
- OCP-1Z0-新051-61题版本-15
- OCP-1Z0-新051-61题版本-16
- OCP-1Z0-新051-61题版本-54
- 【C#】AviFile使用
- JPQL语法总结
- Network Component Analysis(NCA)
- OCP-1Z0-新051-61题版本-55
- OCP-1Z0-新051-61题版本-56
- 有无奈有快乐的银行系统----My Love.
- JDK 压力测试工具——jps、jinfo、jstat、jmap、jconsole
- Sql Server 获取、增加、修改、删除 字段描述
- SQL 中exists的用法
- OCP-1Z0-新051-61题版本-57
- 用QTP调用VB6生成的DLL实例
- OCP-1Z0-新051-61题版本-58
- 图像处理-线性滤波-1 基础(相关算子、卷积算子、边缘效应)