nerdexam
Dell-EMC

E20-120 · Question #352

E20-120 Question #352: Real Exam Question with Answer & Explanation

Sign in or unlock E20-120 to reveal the answer and full explanation for question #352. The question stem and answer options stay visible for context.

Question

Annotations on a document are represented using dm_relation objects. On the dm_relation object, both parent_id and child_id point to a dm_sysobject. The object pointed to by the parent_id is the document and the object pointed to by the child_id is the annotation. The annotation object is owned by the person who commented on the document. Which query will return all documents owned by `John Smith' that have annotations along with the name of the user that commented on the document?

Options

  • ASELECT p.object_name, p.owner_name
  • BSELECT p.object_name, c.owner_name
  • CSELECT object_name, owner_name
  • DSELECT p.object_name, c.owner_name

Unlock E20-120 to see the answer

You've previewed enough free E20-120 questions. Unlock E20-120 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full E20-120 Practice