📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store

    • Question

      To remove all rows from a table without logging individual row deletions and without firing triggers, which command would you typically use?

      A `DELETE FROM table_name;` Correct Answer Incorrect Answer
      B `DROP TABLE table_name;` Correct Answer Incorrect Answer
      C `TRUNCATE TABLE table_name;` Correct Answer Incorrect Answer
      D `TRUNCATE TABLE table_name;` Correct Answer Incorrect Answer
      E `TRUNCATE TABLE table_name;` Correct Answer Incorrect Answer

      Solution

      `TRUNCATE TABLE table_name;`

      Practice Next
      ask-question