Answer Posted / Vimal Kumar

Truncate and Delete are both used to remove data from a table, but they behave differently. Truncate quickly sets the number of rows in a table to zero and releases the space occupied by the table. It does not generate redo or undo logs, making it faster than Delete. On the other hand, Delete removes specific rows based on a WHERE clause and generates redo and undo logs. A full table scan will behave similarly after both operations.

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category