Oracle Database MySQL 5.6 Developer — Question 24

A SELECT statement without an ORDER BY clause return some rows.
Which statement is always true about the order of the returned results?

Answer options

• A. The results are in ascending order.
• B. The results are in descending order.
• C. The results are in the order inserted.
• D. The results are not in a set order.

Correct answer: C

Explanation

The correct answer is C because without an ORDER BY clause, the database does not guarantee the order of the results, but they may appear in the order they were inserted. Options A and B are incorrect as results can be in neither strict ascending nor descending order. Option D is also correct in stating there is no guaranteed order, but C is more specific regarding the potential order based on insertion.