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

Which of the following statement(s) is/are TRUE about DCL?

15. Which of the following statement(s) is/are TRUE about DCL?

1. The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
2. There will be certain privileges that each user has; consequently, the data can be accessed by them.
3. The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
4. All of the above

Answer: D) All of the above

Explanation:

About DCL Commands –

1. The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
2. There will be certain privileges that each user has; consequently, the data can be accessed by them.
3. The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.