Question

You need to remove all data from a table named Products. Which query fully logs the removal of each record?

a) DELETE FROM Products;
b) TRUNCATE TABLE Products;
c) DROP TABLE Products;
d) DELETE * FROM Products;

Answer 1

To log the removal of each record in the Products table, use the query DELETE FROM Products; which logs every deletion.

Step-by-step explanation:

To remove all data from the Products table and ensure that the removal of each record is fully logged, the correct query is: a) DELETE FROM Products; This SQL command will delete every row in the Products table, and the action will be logged in the transaction log, allowing for a point-in-time recovery if needed. The TRUNCATE TABLE command (option b) efficiently removes all rows but does so without logging the deletion of individual rows, making it faster but not as safe if you need to recover specific deleted records. DROP TABLE command (option c) removes the entire table structure along with the data, and again, does not log individual row deletions. Lastly, option d) is incorrect syntax for SQL.