Question 38

In order to add a new column to an existing table in SQL, we can use the command

  1. AMODIFY TABLE
  2. BEDIT TABLE
  3. CALTER TABLE
  4. DALTER COLUMNS
Show answerHide answer

Correct answer: (C) ALTER TABLE

Explanation

ALTER TABLE ... ADD column_name datatype adds a new column to an existing table. MODIFY TABLE and EDIT TABLE are not SQL commands.

From DSSSB TGT Computer Science Practice Set 4

This is question 38 of DSSSB TGT Computer Science Practice Set 4. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.