Oracle
1Z0-882 · Question #37
1Z0-882 Question #37: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
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
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.