I received 1 of the online test and over there the following question has been asked. I already gave answer but curious to cross check my answer with your guidance..
Question
Which piece of information show explain plan if in SQL indicate that a select distinct is being done in the SQL.
Choices are:
a-sort join
b-sort order by
c-sort unique
d-sort aggregate
e-sort group by
My Answer
I gave SORT aggregate but it looks like its sort unique because when I executed explain plan then I can see hash(unique). Please guide