Multiple Choice
Based on the table below, which of the following statements will return the number of customers in Michigan (MI) ?
Customer table
A) SELECT COUNT(*) FROM Customer WHERE State = 'MI'
B) SELECT AVG(*) FROM Customer WHERE State = 'MI'
C) SELECT MAX(*) FROM Customer WHERE State = 'MI'
D) SELECT SUM(*) FROM Customer WHERE State = 'MI'
Correct Answer:

Verified
Correct Answer:
Verified
Q14: If you want to find out about
Q17: "SQL injection attacks" have been responsible for
Q18: Insert the statement that would remove the
Q20: A _ object can create statement objects
Q61: Which of the following statements is correct?<br>A)
Q67: What statement will return the value of
Q69: What does the execute method return?<br>A)ResultSet<br>B)Query<br>C)RecordSet<br>D)boolean
Q70: Which of the following table attributes could
Q71: What is the effect of the following
Q74: The _ class has a next method