πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!

  • google app store apple app store
  • βœ–

      Question

      Which SQL command is used to remove all records from a

      table but keeps the table structure intact?
      A DROP Correct Answer Incorrect Answer
      B DELETE Correct Answer Incorrect Answer
      C TRUNCATE Correct Answer Incorrect Answer
      D REMOVE Correct Answer Incorrect Answer
      E CLEAR Correct Answer Incorrect Answer

      Solution

      While DELETE can also remove records, TRUNCATE is a DDL command that quickly removes all rows from a table without logging individual row deletions.

      Practice Next
      ask-question