Quiz 1Z0-053

Quiz 1Z0-053, Oracle Database 11g: Administration II

Which three are the valid statements in relation to SQL plan baselines?

Which statement is true when you accept the suggested SQL profile?

Which two statements about the SQL Management Base (SMB) are true?

Which client requests to the database can be captured as a part of the workload capture?

which recommendations does the SQL Access Advisor generate?

Which tasks are run automatically as part of the Automated Maintenance Task by default?

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?

Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

Which statement is true about the effect of the above command?

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?