Home »
MCQs »
MySQL MCQs
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?
25. 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?
- DELETE
- TRUNCATE
- DROP
- CLEAR
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.