What Is the Default Sort Direction in ORDER BY?

Question

A query ends with ORDER BY title, without ASC or DESC. How are the rows sorted? Choose one answer.

Answer 1

It depends on the database: ascending in some, descending in others

Answer 2

In ascending order (ASC): from A to Z, from smallest to largest

Answer 3

In descending order (DESC): from Z to A, from largest to smallest

Answer 4

They are not sorted: the rows come in the order they were inserted

Answer 5

There is no default: the query fails until ASC or DESC is written