Q. If you are asked to delete the entire data of a table without disturbing the table definition then in such case which statement you will use?

  • (A) DELETE
  • (B) TRUNCATE
  • (C) DROP
  • (D) CLEAR
💬 Discuss
✅ Correct Answer: (B) TRUNCATE
Explanation: To only remove the data of the table without disturbing the definition of the table we use the TRUNCATE statement, this statement helps us to delete all the data of a table.

Published by Jatin Dubey ⭐ 3.78K Points at 16-Mar-2023 05:03 pm in MySQL

Explanation by: Jatin Dubey
To only remove the data of the table without disturbing the definition of the table we use the TRUNCATE statement, this statement helps us to delete all the data of a table.

💬 Discussion

📊 Question Analytics

👁️
300
Total Visits
📽️
3 y ago
Published
🎖️
Jatin Dubey
Publisher
📈
86%
Success Rate