Q. What does `TRUNCATE TABLE` do?

  • (A) Deletes table structure and data
  • (B) Deletes data only and resets identity
  • (C) Deletes only selected rows
  • (D) Clears only NULL values
💬 Discuss
✅ Correct Answer: (B) Deletes data only and resets identity
Explanation: `TRUNCATE TABLE` removes all rows and resets any `AUTO_INCREMENT` counter.

Published by Mr. Dubey ⭐ 110.87K Points at 06-Jun-2025 10:30 pm in MySQL

Explanation by: Mr. Dubey
`TRUNCATE TABLE` removes all rows and resets any `AUTO_INCREMENT` counter.

💬 Discussion

📊 Question Analytics

👁️
84
Total Visits
📽️
1 y ago
Published
🎖️
Mr. Dubey
Publisher
📈
80%
Success Rate