What is the difference between Delete, Drop, and Truncate?

Question

Accepted Answer

Delete removes specific rows from a table, Drop deletes the entire table, and Truncate deletes all rows from a table.

Delete is a DML operation while Drop and Truncate are DDL operations.
Delete can be rolled back, while Drop and Truncate cannot be rolled back.
Delete operation is slower compared to Drop and Truncate.
Delete operation maintains the transaction log, while Drop and Truncate do not.
Delete operation triggers delete triggers, while Drop and Truncate do not trigger any triggers.
Example: DELETE FROM table_name WHERE condition;
Example: DROP TABLE table_name;
Example: TRUNCATE TABLE table_name;

Accepted Answer

What is bug life cycle?

Popular interview questions of Senior QA Engineer