📊 MySQL
Q. Select the correct statement.
  • (A) DDL consist of 4 commands
  • (B) DCL consist of 2 commands
  • (C) TCL consist of 5 commands
  • (D) DML consist of 3 commands
💬 Discuss
✅ Correct Answer: (B) DCL consist of 2 commands

Explanation: DDL consist of 5 commands, i.e., CREATE, ALTER, DROP, TRUNCATE & RENAME.

DML consist of 4 commands, i.e., SELECT, INSERT, UPDATE & DELETE.

DCL consist of 2 commands, i.e., GRANT & REVOKE.

TCL consist of 3 commands, i.e., COMMIT, ROLLBACK & SAVEPOINT.

Explanation by: Vishal Gupta
DDL consist of 5 commands, i.e., CREATE, ALTER, DROP, TRUNCATE & RENAME.

DML consist of 4 commands, i.e., SELECT, INSERT, UPDATE & DELETE.

DCL consist of 2 commands, i.e., GRANT & REVOKE.

TCL consist of 3 commands, i.e., COMMIT, ROLLBACK & SAVEPOINT.

💬 Discussion

📊 Question Analytics

👁️
226
Total Visits
📽️
3 y ago
Published
🎖️
Vishal Gupta
Publisher
📈
89%
Success Rate