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

Home / Programming MCQs / MySQL MCQs / Question

Vishal Gupta • 7.73K Points
Tutor III

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

Correct answer: Option(D)

MySQL Share

Explanation by: Vishal Gupta

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

Previous MCQ Next MCQ