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?
- A.
DROP removes both the table structure and table data.
- B.
TRUNCATE removes all rows while preserving the table structure.
- C.
TRUNCATE is generally faster than DELETE for removing all rows from a table.
- D.
TRUNCATE can always be reversed using ROLLBACK regardless of the DBMS implementation.
- E.
DROP removes associated indexes and constraints along with the table.
Attempted by 484 students.
Sign up free to check your answer
Sign up freeLoading lesson…

