Dell-EMC
E20-120 · Question #222
A user named John needs to find which of his documents are checked out. How would you complete the following query to accomplish this? select object_name from dm_document _____
The correct answer is B. whereowner_name='John' and r_lock_owner is null. See the full explanation below for the reasoning.
Question
A user named John needs to find which of his documents are checked out. How would you complete the following query to accomplish this? select object_name from dm_document _____
Options
- Awherer_lock_owner='John'
- Bwhereowner_name='John' and r_lock_owner is null
- Cwhereowner_name='John' and r_lock_owner is true
- Dwhereowner_name='John' and r_lock_owner='John'
How the community answered
(25 responses)- A4% (1)
- B80% (20)
- C12% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.