Dell-EMC
E20-120 · Question #220
A user wants to search for a document in which the subject is set to either 'server' or 'Server.' Which DQL query will do this?
The correct answer is C. selectobject_name from dm_document where upper(subject) = 'SERVER'. See the full explanation below for the reasoning.
Question
A user wants to search for a document in which the subject is set to either 'server' or 'Server.' Which DQL query will do this?
Options
- Aselectobject_name from dm_document where subject like '%erver'
- Bselectobject_name from dm_document where subject = 'Server'
- Cselectobject_name from dm_document where upper(subject) = 'SERVER'
- Dselectobject_name from dm_document where upper(subject) = 'Server'
How the community answered
(19 responses)- B11% (2)
- C84% (16)
- D5% (1)
Community Discussion
No community discussion yet for this question.