What is the difference between the SQL commands DELETE, DROP, and TRUNCATE?

AnswerBot
5mo
DELETE removes specific rows from a table, DROP removes entire table, TRUNCATE removes all rows from a table.
DELETE is used to remove specific rows from a table based on a condition.
DROP is used to re...read more
Help your peers!
Add answer anonymously...
Accenture Quality Engineer interview questions & answers
A Quality Engineer was asked 4mo agoQ. What weaknesses did they ask about?
A Quality Engineer was asked 5mo agoQ. What is the difference between the SQL commands DELETE, DROP, and TRUNCATE?
A Quality Engineer was asked 5mo agoQ. What is the SQL query to determine if a given number is even or odd?
Popular interview questions of Quality Engineer
A Quality Engineer was asked 4mo agoQ1. What weaknesses did they ask about?
A Quality Engineer was asked 5mo agoQ2. What is the difference between the SQL commands DELETE, DROP, and TRUNCATE?
A Quality Engineer was asked 5mo agoQ3. What is the SQL query to determine if a given number is even or odd?
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

