Q164 As the DBA, you execute this command

Q164 As the DBA, you execute this command:

 GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION;

USR1 then executes this command:

GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION;

USR2 then executes this command:

GRANT CREATE VIEW TO usr3;

Which statement is true?

• A.When USR1 revokes the CREATE VIEW Privilege from USR2, it is revoked from USR3.
• B.The DBA can revoke only ADMIN OPTION from USR1
• C.When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.
• D.When the DBA revokes the CREATE VIEW Privilege from USR1, it is neither revoked from USR2 nor USR.3.
• E.USRI can revoke the CREATE VIEW privilege from USR3
• F.When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 and USR3.