Oracle
1Z0-061 · Question #231
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?
The correct answer is D. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to. this is the correct solution for the answer. GRANT role_name to users;
Controlling User Access
Question
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?
Options
- ACREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT registrar to
- BCREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT registrar to
- CCREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT ROLE
- DCREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to
- ECREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;
How the community answered
(43 responses)- A9% (4)
- B2% (1)
- C2% (1)
- D74% (32)
- E12% (5)
Explanation
this is the correct solution for the answer. GRANT role_name to users;
Topics
#CREATE ROLE#GRANT privilege#role management#UPDATE privilege
Community Discussion
No community discussion yet for this question.