Oracle
1Z0-061 · Question #259
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)
The correct answer is B. It allows the MANAGER to pass the specified privileges on to other users. E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES. GRANT ROLE to ROLE/USER
Controlling User Access
Question
Examine the statement:
GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)
Options
- AMANAGER must be a role.
- BIt allows the MANAGER to pass the specified privileges on to other users.
- CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
- DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
- EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES
- FIt allows the MANAGER the ability to select from, delete from, and update the
How the community answered
(34 responses)- B79% (27)
- C3% (1)
- D12% (4)
- F6% (2)
Explanation
GRANT ROLE to ROLE/USER
Topics
#GRANT#WITH GRANT OPTION#object privileges#DML privileges
Community Discussion
No community discussion yet for this question.