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


    Question

    Which SQL statement is used to remove all rows from a

    table without logging individual row deletions?
    A DELETE Correct Answer Incorrect Answer
    B TRUNCATE Correct Answer Incorrect Answer
    C DROP Correct Answer Incorrect Answer
    D MERGE Correct Answer Incorrect Answer
    E UPDATE Correct Answer Incorrect Answer

    Solution

    TRUNCATE removes all rows efficiently without logging each row deletion, unlike DELETE.

    Practice Next
    ask-question