🎖️🏵️ Memorial Weekend Sale — 30% off🏵️🎖️

1 day, 1 hour remaining!
CompTIA Study Materials
AWS Study Materials
AWS Certified Developer Associate AWS Certified Developer Associate
AWS Certified Developer Associate DVA-C02
AWS Certified Solutions Architect Associate AWS Certified Solutions Architect Associate
AWS Certified Solutions Architect Associate SAA-C03
AWS Cloud Practitioner AWS Cloud Practitioner
AWS Cloud Practitioner CLF-C02
Microsoft Study Materials
Microsoft Azure Fundamentals Microsoft Azure Fundamentals
Microsoft Azure Fundamentals AZ-900

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?

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

  • DELETE FROM Customer WHERE Status = 'Closed';

  • DROP TABLE Customer;

  • REMOVE FROM Customer WHERE Status = 'Closed';

  • TRUNCATE TABLE Customer;

This question is for objective:
Database Fundamentals
Your Score:
Database Fundamentals
Infrastructure
Applications and Software
Software Development Concepts
Security
IT Concepts and Terminology