Quiz 1Z0-054

Quiz 1Z0-054, Oracle Database 11g: Performance Tuning

What impact would it have on the goal of the optimizer for that session?

Which two actions would you recommend to choose a goal for the optimizer based on the needs of your application?

Which three factors influence the optimizer’s behavior while choosing an optimization approach and goal for a SQL statement?

What could be the reason for it?

Why would the optimizer choose full table scan over index unique scan?

What would you recommend to influence the selectivity calculated by the optimizer?

What can you do to make the optimizer detect the actual number of rows?

What would you recommend to improve the optimizer’s estimation?

Why is the query using a full table scan instead of an index scan?

What could be the reason?