Which clause eliminates repetition so values appear only once?
ADISPATCH
BDISPLAY
CDISCOUNT
DDISTINCT
Answer & Solution
Correct answer: D. DISTINCT
1. A column may repeat the same value across many rows.
2. One clause collapses those repeats.
3. The DISTINCT clause eliminates repetition and displays the values only once.
4. So the answer is DISTINCT.
_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Keep practising Structured Query Language
Browse all Structured Query Language questions for IGNOU MCA, or explore more Computer Science topics.