# POS 410 Week 3 Quiz

PLDZ-2384
In Stock
\$ 6.99 USD
UopTutorialStore
Description

POS 410 Week 3 Quiz

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
Recent Reviews Write a Review
0 0 0 0 reviews