Home » MCQs » SQL MCQs » SQL Commands: DDL, DML, DCL, TCL, DQL MCQs

Select the correct statement (2)

19. Select the correct statement (2)

1. DDL consist of 4 commands
2. DCL consist of 2 commands
3. TCL consist of 5 commands
4. DML consist of 3 commands

Answer: B) DCL consist of 2 commands

Explanation:

1. DDL consist of 5 commands, i.e., CREATE, ALTER, DROP, TRUNCATE & RENAME.
2. DML consist of 4 commands, i.e., SELECT, INSERT, UPDATE & DELETE.
3. DCL consist of 2 commands, i.e., GRANT & REVOKE.
4. TCL consist of 3 commands, i.e., COMMIT, ROLLBACK & SAVEPOINT.