Question

7 multiple choice 1 point what is the primary difference between the delete and truncate statements in sql? truncate is used to remove specific rows based on conditions, while delete removes all rows from a table. delete is used to delete entire tables, while truncate removes specific rows from a table. delete is used to remove specific rows based on conditions, while truncate removes all rows from a table. truncate is used to delete entire tables, while delete removes specific rows from a table.

Explanation:

• DELETE statement: Can be used to remove specific rows from a table based on a WHERE clause (conditions). For example, DELETE FROM table_name WHERE column = value;
• TRUNCATE statement: Removes all rows from a table. It is a faster operation (in some cases) than deleting rows one - by - one (as DELETE might do when removing all rows without a WHERE clause in some database systems). It resets the identity (auto - increment) counter (if applicable) and has less logging in some database engines compared to a DELETE operation that removes all rows.

Answer:

Third option: DELETE is used to remove specific rows based on conditions, while TRUNCATE removes all rows from a table.