单项选择题
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above
相关考题
-
单项选择题
WhichoftheseappropriatelydescribestheresultsofamanualSQLTuningAdvisortask？（）
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor，with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
D. All of the above -
单项选择题
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）
A. The command produces an error because the retention period cannot be reduced
B. All historical data older than 3 years is purged from the flashback archive FLA1
C. All historical data is retained but the subsequent flashback data archives are maintained for only 3 years
D. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time -
单项选择题
ToviewtheresultsofamanualSQLTuningAdvisortask，whichstepsshouldtheDBAtake？（）
A. From the Advisor Central home page，select the tuning task from the Advisor Tasks section
B. From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task Results
C. From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task Results
D. Either B or C
