Question

    Truncate command in SQL

    A TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes, and so on remain. Correct Answer Incorrect Answer
    B The working of truncate command is similar to the working of Delete command without a where clause. Correct Answer Incorrect Answer
    C TRUNCATE TABLE tablename; Correct Answer Incorrect Answer
    D Both 1 and 2 are correct Correct Answer Incorrect Answer
    E All are correct Correct Answer Incorrect Answer

    Solution

    The correct answer is E

    Practice Next