You execute these statements: Connect / as sysdba; Create role r1; Grant r1 to oe with admin option; Connect oe/oe; Grant r1 to hr with admin option; Connect hr/hr; Revoke r1 from oe; What will be the result of the last command?
A. The command will fail because CASCADE was not specified.
B. The role will be revoked from OE but not from HR.
C. The command will fail because the grantee of a role cannot revoke it from the grantor.
D. The role will be revoked from HR but not from OE.