nerdexam
Oracle

1Z0-882 · Question #3

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

The correct answer is D. The results are not in a set order. The results are not in a set order. It is impacted by index , if there is index ,it will return a ascending order , if there is not any index ,it will return the order inserted .

SQL Data Manipulation

Question

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

Options

  • AThe results are in ascending order.
  • BThe results are in descending order.
  • CThe results are in the order inserted.
  • DThe results are not in a set order.

How the community answered

(57 responses)
  • A
    5% (3)
  • B
    9% (5)
  • C
    4% (2)
  • D
    82% (47)

Explanation

The results are not in a set order. It is impacted by index , if there is index ,it will return a ascending order , if there is not any index ,it will return the order inserted .

Topics

#SELECT statement#ORDER BY#result ordering#SQL fundamentals

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-882 Practice