DA0-001 · Question #116
What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?
The correct answer is D. DML. SQL is divided into several subsets based on purpose. DML (Data Manipulation Language) covers the four core operations for working with data: INSERT (add), DELETE (remove), UPDATE (modify), and SELECT (retrieve). DDL (Data Definition Language) defines and modifies database…
Question
What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?
Options
- ADDL.
- BDSL.
- CDQL.
- DDML.
How the community answered
(24 responses)- A4% (1)
- B8% (2)
- D88% (21)
Explanation
SQL is divided into several subsets based on purpose. DML (Data Manipulation Language) covers the four core operations for working with data: INSERT (add), DELETE (remove), UPDATE (modify), and SELECT (retrieve). DDL (Data Definition Language) defines and modifies database structures like tables and schemas. DQL (Data Query Language) is sometimes used to refer only to SELECT statements. DSL (Domain-Specific Language) is a general programming term, not an SQL subset. Since the question asks about interacting with the data itself rather than the structure, DML is correct.
Topics
Community Discussion
No community discussion yet for this question.