1. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
  1. SELECT * FROM Persons WHERE FirstName<>'Peter'

  2. SELECT [all] FROM Persons WHERE FirstName='Peter'

  3. SELECT * FROM Persons WHERE FirstName='Peter'

  4. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'


Correct Option: C

Find more quizzes: