In `ORDER BY age ASC, name DESC`, how are rows ordered when two studen…

Question

In `ORDER BY age ASC, name DESC`, how are rows ordered when two students share the same age?

Accepted Answer

C. by name in DESC order (Z to A)

**Multiple sort keys form a hierarchy:** the first key dominates, later keys break ties.
With two students of the same age, name DESC decides
the student whose name sorts later alphabetically (Z-side) appears first.
ORDER BY makes the ordering deterministic instead of leaving it to the engine.

Answer

by insertion order, oldest insert first

Answer

the database picks arbitrarily

Answer

by primary key ascending

In `ORDER BY age ASC, name DESC`, how are rows ordered when two students share the same age?

Keep practising Database Management Systems