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

Which of the following SQL commands is used to change the attribute values of one or more rows in a table?

  1. AUpdate
  2. BInsert
  3. CAlter
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (A) Update

Explanation

UPDATE changes the values of existing rows, for example UPDATE t SET col = val WHERE .... INSERT adds rows and ALTER changes the table structure.

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

This is question 125 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.