Which Keyword is used to remove duplicate rows in the result set?

Answer: Option A

This question asks about how to get rid of repeated rows in a table's results.
Imagine you have a list of fruits, and some fruits appear multiple times.
You want to see only one of each fruit, not all the repetitions.
That's what the DISTINCT keyword does.
So the answer is Option C: DISTINCT.
Option A: DISTINCTS is incorrect because it is not a valid keyword.
Option B: MODIFY is used to change the structure of a table, not to remove duplicates.
Option D: All of the mentioned is incorrect because only DISTINCT is the correct keyword.