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 can the user complete the following query to accomplish this?
select object_name from dm_document _____

A.
where r_modify_date = date(yesterday)

B.
where r_modify_date >= date(yesterday)

C.
where r_modify_date > date(yesterday) and r_modify_date < date(today)

D.
where r_modify_date >= date(yesterday) and r_modify_date < date(today)

Explanation: