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.
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: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
Yes…
‘C’ is only the correct answer.
is this question part of this exam? please tell me
tnx