- Description
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 |