Which of the following commands is part of DDL?

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,

Database Fundamentals

Question

Options

AUPDATE
BGRANT
CCREATE
DINSERT

How the community answered

(54 responses)

A
4% (2)
B
4% (2)
C
91% (49)
D
2% (1)

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.

Topics

#DDL#SQL commands#CREATE statement

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice