You are the DBA for an academic database. You need to create a role that allows a group of users to modify
existing rows in the STUDENT_GRADES table.
Which set of statements accomplishes this?
A.
CREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT registrar to user1,
user2, user3
B.
CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT registrar to user1,
user2, user3
C.
CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT ROLE registrar to
user1, user2, user3
D.
CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1,
user2, user3;
E.
CREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;
Explanation:
this is the correct solution for the answer.
GRANT role_name to users;
Incorrect answer:
A:
there is no such MODIFY keyword
B:
invalid CREATE command, there is no such NEW keyword
C:
invalid GRANT command, there is no such ROLE keyword
E:
invalid GRANT command, there is no such CHANGE keyword
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-10