Quiz 1z0-117

Quiz 1z0-117, Oracle Database 11g Release 2: SQL Tuning

What two steps could you take to make the query execute in parallel?

Which query transformation technique is used by the optimizer in this case?

What three actions could you perform to improve the response time of the queries without modifying the SQL statements?

Identify two situations in which full table scans will be faster than index range scans.

How will you optimize the query results without retrieving data blocks from the storage?

Which three options are true about MVIEWs?

Which statement correctly describes the BITMAP AND operation?

Which two statements are true about index full scans?

Which two tasks would you perform to achieve this?

What must you do to use the old statistics?