Question 143Asked in CIL MT Systems, 26 Mar 2017 (12:30 PM)

Which of the following statements about the "DELETE" command is FALSE?

  1. AIt removes tuples from a relation (table).
  2. BIt removes tuples as well as the relation (table).
  3. CA missing WHERE clause specifies that all tuples in the relation are to be deleted.
  4. DDepending on the number of tuples selected by the condition in the WHERE clause, zero, one or several tuples can be deleted by a single DELETE command.
Show answerHide answer

Correct answer: (B) It removes tuples as well as the relation (table).

From CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM)

This is question 143 of CIL MT Systems PYQ, 26 Mar 2017 (12:30 PM). 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.