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


    Question

    Which of the following is used to remove all records

    from a table without removing the table structure?
    A DELETE Correct Answer Incorrect Answer
    B DROP Correct Answer Incorrect Answer
    C TRUNCATE Correct Answer Incorrect Answer
    D REMOVE Correct Answer Incorrect Answer
    E ERASE Correct Answer Incorrect Answer

    Solution

    TRUNCATE deletes all rows quickly while preserving the table structure; DELETE can remove rows conditionally.

    Practice Next
    ask-question