DS0-001 · Question #79
DS0-001 Question #79: Real Exam Question with Answer & Explanation
The correct answer is C: CREATE. CREATE is correct because it belongs to DDL (Data Definition Language) - the SQL subset used to define and modify database structure (schemas, tables, indexes, views). UPDATE and INSERT are DML (Data Manipulation Language) commands that operate on data within existing structures,
Question
Which of the following commands is part of DDL?
Options
- AUPDATE
- BGRANT
- CCREATE
- DINSERT
Explanation
CREATE is correct because it belongs to DDL (Data Definition Language) - the SQL subset used to define and modify database structure (schemas, tables, indexes, views). UPDATE and INSERT are DML (Data Manipulation Language) commands that operate on data within existing structures, not the structures themselves. GRANT is DCL (Data Control Language), used to manage user permissions and access rights.
Memory tip: DDL = "Define the Layout" - think CREATE, ALTER, DROP, TRUNCATE. If a command shapes the container, it's DDL; if it touches the contents, it's DML.
Community Discussion
No community discussion yet for this question.