What does the DELETE operation do?
1Times asked
May 2026Last seen
May 2026First seen
💡 Model Answer
The DELETE statement removes rows from a table that satisfy a specified condition. It is a DML operation that logs each row deletion, fires any DELETE triggers, and can be rolled back if executed within a transaction. DELETE can target a subset of rows using a WHERE clause, or all rows if no condition is provided. It is slower than TRUNCATE for large tables because it processes rows individually.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500