Multiple choice technology mainframe

Given the Table STAFF ----------- ID LASTNAME 1 Malleswar 2 Kiran 3 Praveen 4 Yuva When issuing the query "SELECT * FROM STAFF" , the row return order will be based on which of the following?

  1. An ambiguous order

  2. The primary key order

  3. The order that the rows were inserted into the table

  4. The values for the ID column, then the LASTNAME column

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL, a SELECT query without an ORDER BY clause returns rows in an ambiguous, non-guaranteed order. The database is free to return rows in whatever order is most efficient, which depends on the access path chosen by the optimizer. This order is not based on primary key, insertion order, or any specific column value unless explicitly specified. Option A is correct because relational databases make no guarantees about row order without ORDER BY.