Quiz 1z0-117

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

Which two statements are true about the trcsess utility?

Identify the task(s) that must be performed to accomplish this.

Which statement is correct about the parallel executions plan?

Which three statements are true the Automatic Tuning Optimizer (ATO)?

Which two statements are correct?

Why is sort-merge join chosen as the access method?

Which four types of column filtering may benefit from partition pruning when accessing tables via partitioned indexes?

Which three statements are true about EXPLAIN PLAN?

Which three factors does the estimator depend on for overall cost estimation of a given execution plan?

Which two are true about the DSS_PLAN resource manager plan?