As a database administrator, you need to remove all rows from the Customer table where the Status column equals "Closed" while leaving the table itself intact. Which SQL statement should you run?
Use DELETE FROM Customer WHERE Status = 'Closed'; to remove only the rows whose Status value is Closed. DELETE is a data-manipulation command, so the table definition, indexes, and other rows remain. TRUNCATE TABLE Customer deletes every row in the table, DROP TABLE Customer removes the entire table and its schema, and SELECT merely reads data without altering it.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the difference between DELETE and TRUNCATE in SQL?
Open an interactive chat with Bash
Why does DROP TABLE remove both the data and structure?