DBMS · Question 4 · Easy
The SQL commands GRANT and REVOKE belong to which category of SQL statements?
- DCL (Data Control Language)
- DDL (Data Definition Language)
- DML (Data Manipulation Language)
- TCL (Transaction Control Language)
Answer and explanation
Answer: A. DCL (Data Control Language)
Explanation: GRANT and REVOKE control access privileges, so they are Data Control Language commands. COMMIT/ROLLBACK are TCL, CREATE/ALTER are DDL.
Previous: Among all candidate keys of a relation, the one chosen by the database… · Next: In an ER diagram (Chen notation), how is a weak entity set drawn?
Practise dbms
Try a fresh set of dbms questions with an explanation after every answer, free and without signing up: DBMS practice. Or sit a full placement mock test.
More dbms questions
- Which normal form requires that every attribute of a relation hold only atomic…
- In the ACID properties of a transaction, what does the letter 'I' stand for?
- Among all candidate keys of a relation, the one chosen by the database…
- In an ER diagram (Chen notation), how is a weak entity set drawn?
- Relation R(A, B, C) has the functional dependencies A → B and B → C, and A is…
- Relation R(A, B, C, D, E) has the functional dependencies A → B, B → C and CD…
- Transaction T1 reads a row, then transaction T2 updates that row and commits…
- What does the basic Two-Phase Locking (2PL) protocol guarantee?
- Which rule does Write-Ahead Logging (WAL) enforce?
- In a B+ tree index, where are the pointers to actual data records stored?
More technical & programming practice
SQL · Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming
LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge