Oracle Exam 1Z0-063 Topic 6 Question 13 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 13
Topic #: 6

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.

You execute the following command to change the requirement:

SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION 2 YEAR;

What is the outcome?

AAn error is returned because the retention period cannot be reduced.

BAll historical data older than two years, if any, is purged from the flashback archive FDA1.

CAll the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.

DAll historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Show Suggested Answer

Suggested Answer: B

by Oretha at May 05, 2022, 09:38 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!