Multiple choice technology databases

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

  1. DELETE FROM Persons WHERE FirstName = 'Peter'

  2. DELETE FirstName='Peter' FROM Persons

  3. DELETE ROW FirstName='Peter' FROM Persons

  4. DELETE FROM Persons WHERE FirstName <> 'Peter'
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DELETE FROM table WHERE condition removes matching records. The WHERE clause is crucial - without it, all rows would be deleted. Option A is the only correct syntax.

Keep practicing — related questions