Multiple choice technology databases

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

  1. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' ;

  2. SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson';

  3. SELECT FirstName='Peter', LastName='Jackson' FROM Persons

  4. SELECT FirstName LIKE 'Peter', LastName LIKE 'Jackson' FROM Persons
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Use WHERE with AND to combine multiple exact match conditions. LIKE is for pattern matching, not exact values. Option C incorrectly puts conditions in the SELECT clause.

Keep practicing — related questions