Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 11 of 50

Marks: +1, -0

Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)

During parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and which is cached in memory, is always reused for the current execution.
During execution, the Oracle server may read data from storage if the required data is not already in memory.
During row source generation, rows that satisfy the query are retrieved from the database and stored in memory.
During optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution.

Go to Question:

Prev Question

Next Question