Which of the following options correctly identifies Data Control Language (DCL)
commands in SQL Query?
-
A.
CREATE, DROP
-
B.
GRANT, REVOKE
-
C.
SELECT, INSERT
-
D.
UPDATE, DELETE
Correct Answer:
B. GRANT, REVOKE
Explanation:
Data Control Language (DCL) commands are used to manage database security by regulating user access and permissions. The two primary DCL commands are GRANT, which provides specific access rights to a user, and REVOKE, which removes those previously assigned privileges. In contrast, CREATE and DROP are Data Definition Language (DDL) commands used for structural changes, while INSERT, UPDATE, DELETE, and SELECT are Data Manipulation Language (DML) or Data Query Language (DQL) commands used for handling data within tables. Since GRANT and REVOKE are the only options listed that specifically deal with access control, B is the correct choice.
Click below to open Discussion & Feedback
0 Issues
Please
login to comment or Report Issues.