Oracle OCP 19c 認證1Z0-083考試題庫(第7題)
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢Oracle OCP 19c 認證1Z0-083考試題庫(第7題)-CUUG內部學員版083題庫解析
7、choose one
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 fdal MODIFY RETENTION 2 YEAR;
What is the outcome?
A) All historical data older than two years, if any, is purged from the flashback archive FDA1.
B) An error is returned because the retention period cannot be reduced.
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.
Answer :A
(解析:超過 2 年的老數據將會被從閃回數據歸檔區刪除。閃回數據歸檔和閃回日志是完全兩個獨立的概念。)