Question 127Asked in BPSC TRE 2.0 (2023) Computer Science Class 11-12

Which of the following SQL commands is used to modify the structure of a table?

  1. AAlter
  2. BModify
  3. CUpdate
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (A) Alter

Explanation

ALTER TABLE changes a table's structure, for example to add, drop or modify columns. UPDATE changes data, not structure.

From BPSC TRE 2.0 (2023) Computer Science Class 11-12 — Previous Year Paper

This is question 127 of BPSC TRE 2.0 (2023) Computer Science Class 11-12 — Previous Year Paper. 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.