Oracle
1Z0-007 · Question #98
1Z0-007 Question #98: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #98. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe set of statements contains an error and does not work.
- BIt creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES
- CIt creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
- DIt creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES
- EIt creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the
- FIt creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.