1Z0-882 practice - PrepKeys

Q3 Single choice

Given the table City:

SELECT Name
FROM City
WHERE CountryCode = `USA" OR WHERE CountryCode= `JPN'

What does this statement procedure?

A
A single result set with one column that contains the names of cities from country codes USA and JPN.
B
Two result sets each containing a single column with the names of cities from country codes USA and
JPN.
C
A single result set with two columns containing the names from country codes USA and JPN.
D
No result set is returned and an error message is given.