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…

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)…

Database Management and Maintenance

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

How the community answered

(61 responses)

A
2% (1)
C
7% (4)
D
92% (56)

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.

Topics

#DDL commands#ALTER TABLE#Schema modification

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice