Multiple choice technology databases

Which SQL statement is used to delete data from a database table?

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. REMOVE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DELETE is the DML statement used to remove specific rows from a database table based on conditions. DROP removes the entire table structure, TRUNCATE removes all rows but keeps the table structure, and REMOVE is not a standard SQL command. DELETE is the correct choice for removing data while preserving the table.

Keep practicing — related questions