Study tips 1z0-050

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

What two statements are true regarding the recommendations received from the SQL Access Advisor?

What are the advantages of variable extent size support for large ASM files?

What is the correct action to achieve this?

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.

Which two statements about workload capture and replay operations are true?

Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

Which statement describes the effect of table redefinition on the triggers attached to the table?

Which methods would you use to achieve this?

What is the outcome of the above code?