POS 410 Week 3 Quiz
Instructions: Highlight your selected answer, save, and upload the results in the assignments section.
1. With SQL, how do you select all the columns from a table named “Persons”?
a. SELECT *.Persons
b. SELECT Persons
c. SELECT * FROM Persons
d. SELECT [all] FROM Persons
2. With SQL, how do you select all the records from a table named “Persons” where the value of
the column “FirstName” is “Peter”?
a. SELECT * FROM Persons WHERE FirstName LIKE ‘Peter’
b. SELECT [all] FROM Persons WHERE FirstName LIKE ‘Peter’
c. SELECT * FROM Persons WHERE FirstName=’Peter’
d. SELECT [all] FROM Persons WHERE FirstName=’Peter’
3. 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”?
a. SELECT * FROM Persons WHERE FirstName=’%a%’
b. SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
c. SELECT * FROM Persons WHERE FirstName=’a’
d. SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
4. WITH SQL, how do you select all the records from a table named “Persons” where the value of
the column “age” is between 21 and 31?
a. SELECT * FROM Persons WHERE age BETWEEN 21 AND 31
b. SELECT * FROM Persons BETWEEN 21 AND 31
c. SELECT * FROM Persons WHERE age <= 31 5. WITH SQL, how do you calculate the total number of people from a table named “Persons” where the value of the column “LastName” is “Smith”? a. SELECT TOTAL FROM Persons
WHERE LastName = ‘Smith’ b. SELECT LastName, COUNT(*) FROM Persons
WHERE LastName = ‘Smith’
GROUP BY LastName c. SELECT COUNT FROM Persons
WHERE LastName = ‘Smith’
ON LastName