单项选择题
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 were asked to change the retention from 5 years to 3 years. To accomplish this， you issued the following command：
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR；
What is the implication of this command？（）
A. The command produces an error because the retention time cannot be reduced.
B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data older than three years is purged from the flashback archive FLA1.
相关考题
-
单项选择题
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this？（）
A. owner
B. touser
C. attach
D. remap_schema -
多项选择题
WhichstatementsaretrueregardingthecreationofanincidentpackagefilebyusingtheEMWorkbenchSupport？（）
A. You can add or remove the trace files to the package.
B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
C. You can add SQL test cases to the incident package.
D. You cannot create an incremental incident package when the physical files are purged rom the ADR. -
多项选择题
WhichstatementdescribesthesignificanceoftheCHANGEFAILUREcommandinRMAN？（）
A. It is used to change failure priority only for HIGH or LOW priorities.
B. It is used to execute the advised repair script.
C. It is used to change failure priority only for the CRITICAL priority.
D. It is used to explicitly close the open failures.
E. It is used to inform the database about the repair after the repair script executes.
