Millionaire Mode

SQL Fundamentals and SQL*Plus Commands

Question 1 of 19

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

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000