ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

187 / 190

Question 187:

The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command: SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION; then executes this command to grant privileges to the user JIM: TOM - SQL> GRANT SELET ON hr.bonuses TO jim; Which statement is true? 

Answer options:

A. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.
B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM.
C. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.
D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.