Oracle
1Z0-882 · Question #34
You have two lists of values to correlate. Which query lists all names in colors1 and how many total matches are there in colors2?
The correct answer is D. SELECT colors1.name, count (colors2.name). See the full explanation below for the reasoning.
Question
You have two lists of values to correlate. Which query lists all names in colors1 and how many total matches are there in colors2?
Exhibit
Options
- ASELECT colors1 .name.count (colors2.name)
- BSELECT colors1.name, count(colorse2. Name)
- CSELECT colors1. Name count (colors2.name)
- DSELECT colors1.name, count (colors2.name)
How the community answered
(19 responses)- A11% (2)
- B11% (2)
- C5% (1)
- D74% (14)
Community Discussion
No community discussion yet for this question.