nerdexam
Dell-EMC

E10-110 · Question #154

A user wants to search for a document whose subject is set to "server" or "Server". Which DQL query will do this?

The correct answer is A. select object_name from dm_document where lower(subject) = 'server'. See the full explanation below for the reasoning.

Question

A user wants to search for a document whose subject is set to "server" or "Server". Which DQL query will do this?

Options

  • Aselect object_name from dm_document where lower(subject) = 'server'
  • Bselect object_name from dm_document where subject like '%erver'
  • Cselect object_name from dm_document where subject like '?erver'
  • Dselect object_name from dm_document where lower(subject) = 'Server'

How the community answered

(41 responses)
  • A
    80% (33)
  • B
    10% (4)
  • C
    2% (1)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full E10-110 Practice