Pop Quiz 2

Question 1

Which function should be used to calculate the total of all values in a column?

A. Count
B. Sum
C. Total

Answer 1

Sum

Question 2

Based on the following table description, use SQL to list the complete STUDENT table.
STUDENT[StudentID, FirstName, LastName, Street, City, State, Zip]

A. SELECT all from STUDENT;
B. LIST all from STUDENT;
C. SELECT * from STUDENT;

Answer 2

SELECT * from STUDENT;