Home » MCQs » SQL MCQs » SQL Table MCQs

Select the correct statement (3)

14. Select the correct statement.

1. TRUNCATE TABLE is faster than DELETE TABLE statement.
2. TRUNCATE TABLE uses fewer resources than DELETE TABLE statement.
3. Both A) and B)
4. None of the above

Answer: C) Both A) and B)

Explanation:

TRUNCATE TABLE uses fewer resources and is faster than DELETE TABLE command.