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. 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…

Controlling User Access

Question

Options

ACREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar;
BCREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar;
CCREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar;
DCREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar;
ECREATE registrar; GRANT CHANGE ON student_grades TO registrar;

How the community answered

(54 responses)

A
2% (1)
B
4% (2)
C
11% (6)
D
80% (43)
E
4% (2)

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

Topics

#CREATE ROLE#GRANT privilege#roles#UPDATE privilege

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice