You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled

Post by answerhappygod »

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 older than three years is purged from the flashback archive FLA1.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply