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 therole, 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.
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:
A the statement does not contain error
B there is no MODIFY privilege
D statement does not create 3 users with the role
E privilege is grant to role then grant to user
F privilege is grant to role then grant to user