Dell-EMC
E20-120 · Question #224
A user wants to write a DQL query that can be run on a daily basis to determine which documents were modified on the previous day. How would you complete the following query to accomplish this?…
The correct answer is D. where r_modify_date >= date(yesterday) and r_modify_date < date(today). See the full explanation below for the reasoning.
Question
A user wants to write a DQL query that can be run on a daily basis to determine which documents were modified on the previous day. How would you complete the following query to accomplish this? select object_name from dm_document _____
Options
- Awhere r_modify_date = date(yesterday)
- Bwhere r_modify_date >= date(yesterday)
- Cwhere r_modify_date > date(yesterday) and r_modify_date < date(today)
- Dwhere r_modify_date >= date(yesterday) and r_modify_date < date(today)
How the community answered
(40 responses)- A5% (2)
- B3% (1)
- C10% (4)
- D83% (33)
Community Discussion
No community discussion yet for this question.