POS 410 Week 3 Quiz

**********************************************  POS 410 Entire Course Link   https://uopcourses.com/category/pos-410/   **********************************************

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    
sellfy