Which of the following best describes the category of SQL commands required to revoke access to database objects?

Question

Options

• ADDL
• BDCL
• CTCL
• DDML

• A
  88% (46)
• B
  2% (1)
• C
  6% (3)
• D
  4% (2)

Explanation

There's an error in the provided answer key - the correct answer is B (DCL), not A.

REVOKE (along with GRANT) belongs to Data Control Language (DCL), which is the SQL command category specifically designed to manage permissions and access to database objects. DCL commands control who can do what within a database, making it the only category that handles revoking access.

Why the distractors are wrong:

• A (DDL - Data Definition Language): DDL commands (CREATE, ALTER, DROP) define and modify the structure of database objects, not permissions.
• C (TCL - Transaction Control Language): TCL commands (COMMIT, ROLLBACK, SAVEPOINT) manage transactions, not access rights.
• D (DML - Data Manipulation Language): DML commands (SELECT, INSERT, UPDATE, DELETE) manipulate data within tables, not access controls.

Memory tip: Think of DCL = "Database Cop Language" - the "cop" GRANTS permission or REVOKEs it. Everything else (DDL = structure, DML = data, TCL = transactions) has nothing to do with security permissions.

No community discussion yet for this question.