πŸ“Š MySQL
Q. Which of the following is the correct syntax for using the TRUNCATE statement?
  • (A) TUNCATE TABLE-NAME;
  • (B) TRUNCATE TABLE-NAME DATABASE-NAME;
  • (C) TRUNCATE TABLE TABLE-NAME;
  • (D) TRUNCATE DATABASE-NAME TABLE-NAME;
πŸ’¬ Discuss
βœ… Correct Answer: (C) TRUNCATE TABLE TABLE-NAME;

Explanation: The correct syntax to use truncate statement is,

TRUNCATE TABLE TABLE-NAME;

Explanation by: Jatin Dubey
The correct syntax to use truncate statement is,

TRUNCATE TABLE TABLE-NAME;

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
244
Total Visits
πŸ“½οΈ
3 y ago
Published
πŸŽ–οΈ
Jatin Dubey
Publisher
πŸ“ˆ
82%
Success Rate