DS0-001 · Question #144
DS0-001 Question #144: Real Exam Question with Answer & Explanation
The correct answer is D: ALTER TABLE. ALTER TABLE is the correct DDL (Data Definition Language) command because it modifies the structure of an existing table - adding, dropping, or renaming columns - which is exactly what's needed when a table has incorrect columns. SELECT is a DML (Data Manipulation Language) comma
Question
A database administrator realizes that a database does not have the correct columns. The administrator needs to modify the structure using a DDL command. Which of the following should the administrator use?
Options
- ASELECT
- CINSERT
- DALTER TABLE
Explanation
ALTER TABLE is the correct DDL (Data Definition Language) command because it modifies the structure of an existing table - adding, dropping, or renaming columns - which is exactly what's needed when a table has incorrect columns.
SELECT is a DML (Data Manipulation Language) command used to read data, not change structure. INSERT is also DML, used to add rows of data to an existing table, not to change columns. Neither SELECT nor INSERT touch the schema at all.
Memory tip: Think "ALTER = alter the architecture." DDL commands (CREATE, ALTER, DROP) deal with the blueprint of the database, while DML commands (SELECT, INSERT, UPDATE, DELETE) deal with the data inside that blueprint.
Community Discussion
No community discussion yet for this question.