Q. What is the difference between DELETE and TRUNCATE?

डिलीट और ट्रंकेट के बीच क्या अंतर है?

A
DELETE removes all rows, TRUNCATE deletes only specific rows
B
DELETE can use WHERE clause, TRUNCATE removes all rows
C
DELETE is faster than TRUNCATE
D
TRUNCATE does not reset auto-increment values

Explanation

Explanation will be available soon. Please stay tuned.

व्याख्या जल्द ही उपलब्ध होगी। कृपया बने रहें।

Invest in Future Achievers

Your support helps keep Exam Achiever 100% free for students preparing for exams.

Thanks for your support!

More From This Topic

Related Questions

Related Topics

Introduction to Database Management System Architecture of Database System Manipulating Data with MariaDB Database Design NoSQL Database Technologies

Comments

Leave a Comment

Invest in Future Achievers

Your support helps keep Exam Achiever 100% free for students preparing for exams.

Thanks for your support!

People Also Search For

Illustration of a clipboard with a checklist and pencil, bright and colorful style

Ready for a Challenge?

Take our Free timed mock tests to sharpen your skills and boost your confidence!