OCP CBT Question 602

Please solve the following question.

User DEVELOPER was granted CREATE TABLE and CREATE VIEW privileges. Later, the DBA needs to revoke CREATE VIEW from DEVELOPER. Which statement is true regarding the REVOKE command for system privileges?

The REVOKE command for CREATE VIEW does not require CASCADE or RESTRICT options.

The REVOKE command for CREATE VIEW must use the CASCADE option if DEVELOPER granted it to others.

The REVOKE command for CREATE VIEW must use the RESTRICT option.

The REVOKE command will fail if DEVELOPER has created views.