🎴 Flashcard Mode
SQL Fundamentals and SQL*Plus Commands
Card1 / 19
Mastered0
Review0
QuestionClick to flip
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
AnswerClick to flip back
A
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' ;
💡 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.