Quiz 1z0-117

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

Which statement is true regarding the execution plan?

Which three statements are true about histograms?

Which statement is true about the execution?

Which four statements are correct about communication between parallel execution process?

which parallel execution is requested?

Which two statements are true about tracing?

Which two types of column filtering may benefit from partition pruning?

Which two statements about In-Memory Parallel Execution are true?

Which two are benefits of In-Memory Parallel Execution?

Which two situations benefit from parallel INSERT operations on tables that have no materialized views defined on them?