Home »
MCQs »
MySQL MCQs
Which of the following is the correct syntax for using the TRUNCATE statement?
26. Which of the following is the correct syntax for using the TRUNCATE statement?
- TUNCATE TABLE-NAME;
- TRUNCATE TABLE-NAME DATABASE-NAME;
- TRUNCATE TABLE TABLE-NAME;
- TRUNCATE DATABASE-NAME TABLE-NAME;
Answer: C) TRUNCATE TABLE TABLE-NAME;
Explanation:
The correct syntax to use truncate statement is,
TRUNCATE TABLE TABLE-NAME;