1Z0-051 Free Dumps Study Materials
Question 6: 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;
Correct Answer: D
Explanation:
this is the correct solution for the answer. GRANT role_name to users;
Incorrect
answer: Athere
is no such MODIFY keyword Binvalid CREATE command, there is no such NEW keyword Cinvalid
GRANT command, there is no such ROLE keyword Einvalid GRANT command, there is no such
CHANGE keyword
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-10