nerdexam
Dell-EMC

E20-120 · Question #221

A user wants to list the names and authors of documents in a repository. The results should be arranged alphabetically by author. Which query will do this?

The correct answer is C. selectobject_name, authors from dm_document order by authors. See the full explanation below for the reasoning.

Question

A user wants to list the names and authors of documents in a repository. The results should be arranged alphabetically by author. Which query will do this?

Options

  • Aselectobject_name, authors from dm_document list by authors
  • Bselectobject_name, authors from dm_document sort by authors
  • Cselectobject_name, authors from dm_document order by authors
  • Dselectobject_name, authors from dm_document group by authors

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    84% (21)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full E20-120 Practice