$5$ What is the difference between executing "TRUNCATE TABLE Customer" and "DELETE Customer"?

$*$

$30$ points

"TRUNCATE TABLE Customer" removes all rows and resets identity values if applicable, whereas "DELETE FROM Customer" allows row$-$by$-$row deletion with the possibility of a WHERE clause.

"TRUNCATE TABLE Customer" deletes specific rows based on a condition, whereas "DELETE FROM Customer" removes all rows without conditions.

Both commands are identical in function and impact on the database, with no differences in their execution or results.

"DELETE FROM Customer" permanently deletes the table structure from the database, whereas "TRUNCATE TABLE Customer" only removes the data but leaves the structure.