OCP-1Z0-新051-61题版本-56

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