Scenario: A DBA is tasked with removing outdated records from a database table. Which SQL command should they utilize for this task?

  • DELETE
  • DROP
  • TRUNCATE
  • REMOVE
The correct option is 'DELETE'. This SQL command is used to remove one or more rows from a table based on the condition specified in the WHERE clause. It allows the DBA to selectively remove outdated records while retaining the structure of the table and other existing data. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *