单项选择题
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?（）
单项选择题 ToviewtheresultsofamanualSQLTuningAdvisortask，whichstepsshouldtheDBAtake？（）
单项选择题 You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）