Oracle
1Z0-882 · Question #37
Examine the fruit and wine tables: Fruit You execute this query: SELECT fruited, fruitname FROM fruit UNION SELECT id, name, country FROM wine; What is the result?
The correct answer is D. The query falls because the number of columns in the SELECT in the SELECT clauses are not. See the full explanation below for the reasoning.
Question
Examine the fruit and wine tables:
Fruit You execute this query:
SELECT fruited, fruitname FROM fruit UNION SELECT id, name, country FROM wine; What is the result?
Exhibit
Options
- AThe query succeeds and returns five columns of data.
- BThe query succeeds and returns two columns of data.
- CThe query falls because UNION does not work on tables with different number of columns.
- DThe query falls because the number of columns in the SELECT in the SELECT clauses are not
How the community answered
(26 responses)- A19% (5)
- B8% (2)
- C4% (1)
- D69% (18)
Community Discussion
No community discussion yet for this question.