Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam

Exam 1z0-063 topic 1 question 212 discussion

Actual exam question from Oracle's 1z0-063

Question #: 212
Topic #: 1

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?

A. An error is returned because the retention period cannot be reduced.
B. All historical data older than two years, if any, is purged from the flashback archive FDA1.
C. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.
D. All 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 NorthKorean at April 24, 2020, 10:17 a.m.

Comments

Submit Cancel

donni

2 years, 10 months ago

it is b

upvoted 1 times

...

chitter

3 years ago

topic 2 question 28 https://www.examtopics.com/exams/oracle/1z0-063/view/52/

upvoted 1 times

chitter

3 years ago

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

upvoted 1 times

...

Simon22

4 years ago

Flashback data archives retain historical data for the time duration specified using the RETENTION parameter. Historical data can be queried using the Flashback Query AS OF clause. Archived historic data that has aged beyond the specified retention period is automatically purged.

upvoted 2 times

...

chris1

4 years, 3 months ago

I would go for B. I could not find any evidence for D in the docs...

upvoted 1 times

...

rcgenilo27

4 years, 10 months ago

B is correct

upvoted 4 times

...

NorthKorean

5 years, 1 month ago

Isn't D ?

upvoted 2 times

joe_doe

4 years, 12 months ago

D is my choice

upvoted 2 times

Sugar

4 years, 11 months ago

D is the correct based on FDA feature. It means that you can use any flashback query which contains two years of historical information regarding the table that is assigned to this flashback archive. it does NOT purge data files though

upvoted 2 times

HakuPudding

3 years, 6 months ago

I agree with you, it does not purge data files. REF: http://www.dba-oracle.com/t_rman_162_modify_flashback_archive.htm

upvoted 1 times

...