Oracle
1Z0-882 · Question #76
What keyword is missing from the following query in order to ensure that all results, including duplicates, are returned? SELECT time, action, user FROM log20040101 UNION SELECT time, action, user…
The correct answer is C. ALL. See the full explanation below for the reasoning.
Question
What keyword is missing from the following query in order to ensure that all results, including duplicates, are returned? SELECT time, action, user FROM log20040101 UNION SELECT time, action, user FROM log20040102
Options
- ANONDISTINCT
- BDUPLICATE
- CALL
- DRELAXED
How the community answered
(47 responses)- A4% (2)
- B2% (1)
- C81% (38)
- D13% (6)
Community Discussion
No community discussion yet for this question.