Home / Programming MCQs / MySQL MCQs / Question

J

Jatin Dubey • 3.78K Points
Extraordinary

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;
Explanation by: Jatin Dubey
The correct syntax to use truncate statement is,

TRUNCATE TABLE TABLE-NAME;

You must be Logged in to update hint/solution

Discusssion

Login to discuss.