nerdexam
Oracle

1Z0-882 · Question #85

What would be the outcome when following statement is executed? SELECT Name FROM City WHERE CountryCode = 'USA' OR WHERE CountryCode = 'JPN'

The correct answer is D. An error message is issued. See the full explanation below for the reasoning.

Question

What would be the outcome when following statement is executed? SELECT Name FROM City WHERE CountryCode = 'USA' OR WHERE CountryCode = 'JPN'

Options

  • AThe city names from USA and JPN in one result set.
  • BThe city names from USA and JPN in two different result sets.
  • CThe city names from USA in the first column and the cities from JPN in the second column.
  • DAn error message is issued.

How the community answered

(45 responses)
  • A
    13% (6)
  • B
    7% (3)
  • C
    2% (1)
  • D
    78% (35)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-882 Practice