单项选择题
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 -
单项选择题
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?（）
A. Create both jobs by using events raised by the scheduler
B. Create both jobs by using events raised by the application
C. Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D. Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application -
单项选择题
WhencreatingaSQLtuningset，whichofthefollowingstepsallowstheDBAtoreducethesizeoftheSQLsetbyselectingspecificoperatorsandvalues？（）
A. Filter versions
B. Filter loads
C. Filter tasks
D. Filter options
