Question: What is the difference between DROP and TRUNCATE?
- They both refer to the same operation of deleting the table completely.
- They both refer to the same operation of clearing the table, but keeping its definition intact.
- TRUNCATE deletes table completely, removing its definition as well. DROP clears the table but does not delete the definition.
- DROP deletes table completely, removing its definition as well. TRUNCATE clears the table but does not delete the definition.
Answer: The correct answer of the above question is Option D:DROP deletes table completely, removing its definition as well. TRUNCATE clears the table but does not delete the definition.