Which statement changes the structure of a table, such as adding a column?
AAMEND TABLE
BADJUST TABLE
CASSIGN TABLE
DALTER TABLE
Answer & Solution
Correct answer: D. ALTER TABLE
1. Changing a column is not changing a row.
2. A structural change needs a structural statement.
3. The ALTER TABLE statement makes changes in the structure of a table.
4. It can add, remove or change the datatype of columns.
_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Keep practising Structured Query Language
Browse all Structured Query Language questions for IGNOU MCA, or explore more Computer Science topics.