When providing partition and index recommendations, which one would SQL Access Advisor source input from?
Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?
Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database. Which would you configure for that to occur?
Which two are functionalities of Oracle Real Application Testing?
DBAs are spending an enormous amount of time trying to identify and fix SQL statements they are suspect have regressed as a result of system changes not documented by the Operations Team. What would you implement to resolve this problem?
Which product technology can assist an Application Developer to capture a full production workload and replay on a test system database?
