nerdexam
Dell-EMC

E10-110 · Question #163

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

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'

How the community answered

(35 responses)
  • A
    6% (2)
  • B
    9% (3)
  • C
    71% (25)
  • D
    14% (5)

Community Discussion

No community discussion yet for this question.

Full E10-110 Practice