KwickClips Databases and SQL · 43 sec · free
Is SELECT DDL or DQL?
Short answer. DQL.
Which group does CREATE TABLE belong to?
DDL.
One command each
| Group | Job | Command |
|---|---|---|
| DDL | structure | CREATE |
| DML | rows | INSERT |
| DQL | read | SELECT |
Remember
| DDL: CREATE |
| DML: INSERT |
| DQL: SELECT |
Is select a D D L or a D Q L command? D D L builds structure, with create. D M L changes rows, with insert. D Q L reads data, with select. Create is D D L. Insert is D M L. Select is D Q L.
This clip is from the full lesson: Introduction to SQL and MySQL: DDL, DML and DQL — 7 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 12 Computer Science (083), CBSE Class 11 Informatics Practices (065), CBSE Class 11 Information Technology (802), CBSE Class 11 Information Technology (802)
More KwickClips from this lesson
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.