Which query will retrieve the names of all document owners and provide a count of the number of documents each user owns?
A. select "owner_name", count(*) from "dm_document" group by "owner_name"
B. select "owner_name", count(*) from "dm_document" order by "owner_name"
C. select "owner_name", count(*) from "dm_document" having owner_name like ‘%’
D. select distinct "owner_name", count(*) from "dm_document"
|
Download Printable PDF. VALID exam to help you PASS. |
 |