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
Q5: What does the following statement do?<br>String prodCode
Q11: Oracle is an example of a:<br>A)Heavyweight Java
Q17: In SQL, the _ command is used
Q28: If your program needs to look at
Q46: What will the following command do?<br>java -classpath
Q49: Based on the customer table below, which
Q55: Based on the table below, the query
Q56: Based on the table below, the query
Q57: In the table below, the _ correspond(s)
Q73: In jdbc.URL, the acronym URL stands for:<br>A)Universal