Suppose you run the following query SELECT FROM STUDENT WHE

Suppose you run the following query: SELECT * FROM STUDENT WHERE LOCATION = ’25 Spivy Hall Road’; As with every SQL query, the result would be a table that:

A. has one or more rows

B. has one column

C. has only one row

D. has zero or more rows

Solution

SELECT * FROM STUDENT WHERE LOCATION = ’25 Spivy Hall Road’;
Answer: D. has zero or more rows