In most standard SQL implementations, which of the following statements…

PYQ IBPS SO CRP SPL-XIV (2024)

In most standard SQL implementations, which of the following statements regarding DROP and TRUNCATE commands is incorrect?

  1. A.

    DROP removes both the table structure and table data.

  2. B.

    TRUNCATE removes all rows while preserving the table structure.

  3. C.

    TRUNCATE is generally faster than DELETE for removing all rows from a table.

  4. D.

    TRUNCATE can always be reversed using ROLLBACK regardless of the DBMS implementation.

  5. E.

    DROP removes associated indexes and constraints along with the table.

Attempted by 484 students.

Sign up free to check your answer

Sign up free

Explore the full course: Ibps So It Mains

Loading lesson…