READ Free Dumps For Oracle- 1z0-050
| Question ID 1833 | What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.) |
| Option A | A. selection of SQL plan baselines |
| Option B | B. partitioning of tables and indexes |
| Option C | C. creation of index-organized tables |
| Option D | D. creation of bitmap, function-based, and B-tree indexes |
| Option E | E. optimization of materialized views for maximum query usage and fast refresh |
| Correct Answer | B,D,E |
| Question ID 1834 | Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements? |
| Option A | A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans. |
| Option B | B. Capture the plans from the previous version using STS and then load them into the stored outline. |
| Option C | C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB). |
| Option D | D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline. |
| Correct Answer | C |