Arrange the following statement(s) in the order of their occurrence when a SELECT query is issued on Oracle database.
Reads data from the data file and keeps a copy in the database buffer cache
Performs syntax and semantic check
Creates an execution plan
Returns the result to the users

(i), (ii), (iii), (iv)

(ii), (iii), (i), (iv)

(i), (iv), (iii), (ii)

(ii), (iv), (iii), (i)

Question

Arrange the following statement(s) in the order of their occurrence when a SELECT query is issued on Oracle database.
Reads data from the data file and keeps a copy in the database buffer cache
Performs syntax and semantic check
Creates an execution plan
Returns the result to the users

(i), (ii), (iii), (iv)

(ii), (iii), (i), (iv)

(i), (iv), (iii), (ii)

(ii), (iv), (iii), (i)

anonymous · Accepted Answer

Correct Solution - b