Oracle OCP 19c 認證1Z0-083考試題庫(第8題)
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢Oracle OCP 19c 認證1Z0-083考試題庫(第8題)-CUUG內部學員版083題庫解析
8、Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
A) 1,3,6
B) 1,2,5
C) 3,4,5
D) 2,3,5,6
Answer：B
(解析：答案 6 是不依賴 undo，答案 3 也是不依賴 undo，使用排除法，正確答案是 B。)
