nerdexam
Dell-EMC

E10-110 · Question #163

E10-110 Question #163: Real Exam Question with Answer & Explanation

The correct answer is C. update dm_document object set authors[0] = 'userA' where object_name = 'document1'. See the full explanation below for the reasoning.

Question

A user wants to replace the first author of a document named "document1" with userA. Which DQL statement will do this?

Options

  • Aupdate dm_document object set authors[1] = 'userA' where object_name = 'document1'
  • Bupdate dm_document object insert authors[0] = 'userA' where object_name = 'document1'
  • Cupdate dm_document object set authors[0] = 'userA' where object_name = 'document1'
  • Dupdate dm_document object insert authors[1] = 'userA' where object_name = 'document1'

Community Discussion

No community discussion yet for this question.

Full E10-110 Practice