MySQL Basic Syntax (Reviewer)

With MySQL, how do you select a column named "FirstName" from a table named "Persons"?

• SELECT Persons.FirstName

• EXTRACT FirstName FROM Persons

• SELECT FirstName FROM Persons  

• SELECT * FROM Persons

With MySQL, how do you select all the columns from a table named "Persons"?

• SELECT *.Persons

• SELECT [all] FROM Persons

• SELECT * FROM Persons  

• SELECT Column Persons

With MySQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

• SELECT [all] FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName<>'Peter'

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'  

With MySQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

• SELECT * FROM Persons WHERE FirstName='%a%'

• SELECT * FROM Persons WHERE FirstName='a'

• SELECT * FROM Persons WHERE FirstName LIKE 'a%'  

• SELECT * FROM Persons WHERE FirstName LIKE '%a'

With MySQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

• SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

• SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

• SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

• SELECT * FROM Persons SORT 'FirstName' DESC

• SELECT * FROM Persons ORDER FirstName DESC

• SELECT * FROM Persons SORT BY 'FirstName' DESC

• SELECT * FROM Persons ORDER BY FirstName DESC 

With MySQL, how can you insert a new record into the "Persons" table?

• INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

• INSERT INTO Persons VALUES ('Jimmy', 'Jackson')  

• INSERT ('Jimmy', 'Jackson') INTO Persons

With MySQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

• INSERT INTO Persons (LastName) VALUES ('Olsen')  

• INSERT INTO Persons ('Olsen') INTO LastName

• INSERT ('Olsen') INTO Persons (LastName)

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

• UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'  

• UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

• MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

• MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

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

• DELETE ROW FirstName='Peter' FROM Persons

• DELETE FirstName='Peter' FROM Persons

• DELETE FROM Persons WHERE FirstName = 'Peter'