By default, ORDER BY displays records in which order?
AAccumulating
BAscending
CAlternating
DAstonishing
Answer & Solution
Correct answer: B. Ascending
1. ORDER BY accepts a direction but does not require one.
2. Leaving it out picks a default.
3. By default, ORDER BY displays records in ascending order of the column's values.
4. So the answer is ascending.
_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.