Free 1Z0-117 Web TestEngine Demo

Q18 Multiple choice

You created a SQL Tuning Set (STS) containing resource-intensive SQL statements. You plan to run the SQL Tuning Advisor.

Which two types of recommendations can be provided by the SQL Tuning Advisor?

Select all that apply.

A
Semantic restructuring for each SQL statement
B
Gathering missing or stale statistics at the schema level for the entire workload
C
Creating a materialized view to benefit from query rewrite for the entire workload
D
Gathering missing or stale statistics for objects used by the statements.
E
Creating a partition table to benefit from partition pruning for each statement

1Z0-117 Web TestEngine demo