Multiple choice technology databases

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

  1. DELETE ROW FirstName='Peter' FROM Persons

  2. DELETE FROM Persons WHERE FirstName = 'Peter'

  3. DELETE FirstName='Peter' FROM Persons

  4. REMOVE FROM Persons WHERE FirstName = 'Peter'
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The standard SQL syntax to delete records from a table is 'DELETE FROM table_name WHERE condition'. The correct option follows this syntax perfectly, whereas the other options use invalid keywords like 'DELETE ROW' or 'REMOVE FROM'.

Keep practicing — related questions