Oracle
1Z0-071 · Question #117
Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)
The correct answer is B. During executing, the oracle server may read data from storage if the required data is not already. See the full explanation below for the reasoning.
Question
Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)
Options
- ADuring parsing, a SQL statement containing literals in the WHERE clause that has been executed
- BDuring executing, the oracle server may read data from storage if the required data is not already
- CDuring row source generation, rows that satisfy the query are retrieved from the database and
- DDuring optimization, execution plans are formulated based on the statistics gathered by the
How the community answered
(34 responses)- A9% (3)
- B74% (25)
- C15% (5)
- D3% (1)
Community Discussion
No community discussion yet for this question.