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
Q65: An important part of database processing is
Q66: Which Java statement connects to a database
Q67: Based on the table below, the query
Q68: What is the main purpose of the
Q69: What does the execute method return?<br>A)ResultSet<br>B)Query<br>C)RecordSet<br>D)boolean
Q70: In the table below, the _ correspond(s)
Q71: Based on the table below, the SQL
Q73: In jdbc.URL, the acronym URL stands for:<br>A)Universal
Q74: The _ class has a next method
Q75: What statement will return the value of