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

    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
    More Computer knowledge Questions
    ask-question