nerdexam
IBM

C2090-558 · Question #36

Which two statements will delete all rows from table_name? (Choose two.)

The correct answer is B. DELETE FROM table_name ; D. TRUNCATE TABLE table_name. See the full explanation below for the reasoning.

Question

Which two statements will delete all rows from table_name? (Choose two.)

Options

  • ADROP FROM table_name ;
  • BDELETE FROM table_name ;
  • CDELETE * FROM table_name ;
  • DTRUNCATE TABLE table_name ;
  • EDELETE ALL FROM table_name ;

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    82% (23)
  • C
    4% (1)
  • E
    11% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice