Oracle
1Z0-882 · Question #35
Given the table City: SELECT Name FROM City WHERE CountryCode = USA" OR WHERE CountryCode= JPN' What does this statementprocedure?
The correct answer is D. No result set is returned and an error message is given. See the full explanation below for the reasoning.
Question
Given the table City:
SELECT Name FROM City WHERE CountryCode = USA" OR WHERE CountryCode= JPN' What does this statementprocedure?
Options
- AA single result set with one column that contains the names of cities from country codes USA and
- BTwo result sets each containing a single column with the names of cities from country codes USA
- CA single result set with two columns containing the names from country codes USA and JPN.
- DNo result set is returned and an error message is given.
How the community answered
(24 responses)- A4% (1)
- B13% (3)
- C4% (1)
- D79% (19)
Community Discussion
No community discussion yet for this question.