Free CompTIA ITF+ FC0-U61 Practice Question

As a database administrator, you have been tasked to remove all records from a customer table that have a 'Closed' status. Which SQL statement should you use to accomplish this task effectively without deleting the table structure itself?

  • REMOVE FROM Customer WHERE Status = 'Closed';

  • SELECT * FROM Customer WHERE Status = 'Closed';

  • DELETE FROM Customer WHERE Status = 'Closed';

  • DROP TABLE Customer;

  • TRUNCATE TABLE Customer;

This question's topic:
CompTIA ITF+ FC0-U61 / 
Database Fundamentals
Your Score:

Check or uncheck an objective to set which questions you will receive.