Oracle Database MySQL 5.6 Developer — Question 11

Given the table City:

SELECT Name -

FROM City -
WHERE CountryCode = ‘USA" OR WHERE CountryCode= ‘JPN’
What does this statement procedure?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because the SQL query is structured to return a single result set with one column that lists the names of cities matching either the USA or JPN country codes. Options B and C are incorrect as the query does not produce multiple result sets or multiple columns. Option D is also incorrect because the syntax is valid and would not generate an error.