Question

    Which command is used to remove all records from a table

    without deleting the table structure?
    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

    TRUNCATE quickly removes all rows from a table, but keeps the structure intact.

    Practice Next