POS 410 Week 3 Quiz | eBooks | Education

POS 410 Week 3 Quiz

POS 410 Week 3 Quiz PLDZ-2384 Instant Download Price
In Stock
$ 6.99 USD
UopTutorialStore
Buy and Download 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

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
Recent Reviews Be the first to Review this product!
0 0 0 0 reviews