Dell-EMC
E10-110 · Question #162
E10-110 Question #162: Real Exam Question with Answer & Explanation
The correct answer is A. select "owner_name", count(*) from "dm_document" group by "owner_name". See the full explanation below for the reasoning.
Question
Which query will retrieve the names of all document owners and provide a count of the number of documents each user owns?
Options
- Aselect "owner_name", count(*) from "dm_document" group by "owner_name"
- Bselect "owner_name", count(*) from "dm_document" order by "owner_name"
- Cselect "owner_name", count(*) from "dm_document" having owner_name like '%'
- Dselect distinct "owner_name", count(*) from "dm_document"
Community Discussion
No community discussion yet for this question.