Question 127Asked in BPSC TRE 2.0 (2023) Computer Class 9-10

Which of the following commands is correct to delete the values in the relation teaches?

  1. ADelete from teaches;
  2. BDelete from teaches where Id='Null';
  3. CRemove table teaches;
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (A) Delete from teaches;

Explanation

'DELETE FROM teaches;' removes all rows (values) of the relation; the other forms are wrong or remove different things.

From BPSC TRE 2.0 (2023) Computer Class 9-10 — Previous Year Paper

This is question 127 of BPSC TRE 2.0 (2023) Computer Class 9-10 — 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.