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?

1. TUNCATE TABLE-NAME;
2. TRUNCATE TABLE-NAME DATABASE-NAME;
3. TRUNCATE TABLE TABLE-NAME;
4. TRUNCATE DATABASE-NAME TABLE-NAME;

Answer: C) TRUNCATE TABLE TABLE-NAME;

Explanation:

The correct syntax to use truncate statement is,

TRUNCATE TABLE TABLE-NAME;