Examine this statement:
What is returned upon execution?
Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 66
Correct Answer: D
Discussion
AzaRzaOption: B
Because both rows are the same, the UNION result gives distinct answers
boddojuOption: B
Option-B is the correct choose
boddoju
my mistake D is the correct answer
Chandru007
yes union all only gives duplicate so it will be 2 rows but union will give 1 row eliminating the duplicates
lucemqyOption: D
Union will get rid of duplicate so only 1 row remaining
HassanMkhlalatiOption: D
It is not union all to return duplicated rows
zouveOption: D
D checked select 1 as id, 'john' as first_name from dual union select 1, 'john' as name from dual order by 1;