Oracle
1Z0-064 · Question #63
1Z0-064 Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Question
You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database. You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version. Which two methods would you use to achieve this? (Choose two.)
Options
- ACreate an SQL Tuning Set (STS) for the SQL statements on the production database and submit
- BCreate an STS for the SQL statements on the production database and submit as input to the
- CGenerate an Automatic Workload Repository (AWR) compare periods report with snapshots
- DCapture the production database workload, replay it on the test system by using Database
- ECreate an STS for the SQL statements on the production database and submit as input to the
- FCreate an STS for the SQL statements on the production database before and after changes and
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.