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




 
 
Powered by