Home » MCQs » SQL MCQs » SQL Commands: DDL, DML, DCL, TCL, DQL MCQs

Difference between GRAND & REVOKE command is/are?

14. Difference between GRAND & REVOKE command is/are?

1. The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
2. The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
3. A transaction can be rolled back to its last saved state.
4. None of the above

Answer: A) The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user

Explanation:

The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.