Sql Query -Quiz

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

• SELECT Persons.FirstName

• EXTRACT FirstName FROM Persons

• SELECT FirstName FROM Persons

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

• SELECT [all] FROM Persons

• SELECT Persons

• SELECT * FROM Persons

• SELECT *.Persons

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

• SELECT * FROM Persons WHERE FirstName='Peter'

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

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

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

With SQL, 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 LIKE '%a'

• SELECT * FROM Persons WHERE FirstName='a'

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

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

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

• SELECT FirstName='Peter', LastName='Jackson' FROM Persons

• SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

• SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

Which SQL statement is used to return only different values?

• SELECT DISTINCT

• SELECT UNIQUE

• SELECT DIFFERENT

Which SQL keyword is used to sort the result-set?

• SORT BY

• ORDER BY

• ORDER

• SORT

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

• SELECT * FROM Persons ORDER BY FirstName DESC

• SELECT * FROM Persons ORDER FirstName DESC

• SELECT * FROM Persons SORT 'FirstName' DESC

• SELECT * FROM Persons SORT BY 'FirstName' DESC

Which operator is used to select values within a range?

• RANGE

• WITHIN

• BETWEEN

Which operator is used to search for a specified pattern in a column?

• FROM

• GET

• LIKE