1Z0-064 · Question #63
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…
The correct answer is A. Create an SQL Tuning Set (STS) for the SQL statements on the production database and submit D. Capture the production database workload, replay it on the test system by using Database. See the full explanation below for the reasoning.
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
How the community answered
(35 responses)- A86% (30)
- B9% (3)
- C3% (1)
- E3% (1)
Community Discussion
No community discussion yet for this question.