MYSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the TRUNCATE statement in MySQL?

How do you use the TRUNCATE statement in MySQL?

What are the differences between the DELETE and TRUNCATE statements?

Can you use the TRUNCATE statement on a table with foreign key constraints?

How does the TRUNCATE statement affect the AUTO_INCREMENT counter in MySQL?

Is TRUNCATE faster than DELETE? Why or why not?

What are the potential risks or drawbacks of using TRUNCATE in MySQL?

How does TRUNCATE interact with triggers in MySQL?

Can you use TRUNCATE with tables that have indexed columns? Explain.

Describe a scenario where TRUNCATE would be preferred over DELETE and explain the steps and considerations involved.