Home / Programming MCQs / MySQL MCQs / Question

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

(A) The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
(B) There will be certain privileges that each user has; consequently, the data can be accessed by them.
(C) 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.
(D) All of the above

Explanation:

About DCL Commands –

The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.

There will be certain privileges that each user has; consequently, the data can be accessed by them.

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.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.