nerdexam
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)
  • A
    9% (3)
  • B
    74% (25)
  • C
    15% (5)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice