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.
It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and
gives the REGISTRAR role to the STUDENT_GRADES object.
B.
It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users,
and gives the UPDATE role to the registrar.
C.
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.
D.
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.
E.
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.
F.
The set of statements contains an error and does not work.
Explanation: