Aptitude Reasoning English GK Computer Knowledge Programming Skill Banking Software Testing

Question

What is the difference between DELETE and TRUNCATE commands?

  • TRUNCATE removes single single rows from the table, whereas DELETE used for delete all rows from a table
  • DELETE use for delete a table whereas TRUNCATE use for delete database
  • DELETE can removes a single row with where condition but TRUNCATE Can not delete single row
  • None of the above


More Test for Practice


Database