[2020年]OCP 19c 認(rèn)證1Z0-083考試題庫(kù)（第5題）-CUUG內(nèi)部學(xué)員版083題庫(kù)解析
5、Which three are true about requirements for various FLASHBACK operations? (Choose three.)
A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
Answer: ABF
(解析：flashback query 只能“穿越”到過去的某個(gè)時(shí)間點(diǎn)上的數(shù)據(jù)庫(kù)版本，但是在當(dāng)前時(shí)間和過去的某個(gè)時(shí)間點(diǎn)上，一個(gè)表中的數(shù)據(jù)可能已經(jīng)被變更多次，單一版本可能無法滿足恢復(fù)的需求。通過 lashback version query 能夠查看指定時(shí)間段內(nèi) undo 表空間中被提交的記錄的不同版本。
Flashback Transaction Query 也是使用 UNDO 信息來實(shí)現(xiàn)。利用這個(gè)功能可以查看某個(gè)事務(wù)執(zhí)行的所有變化，它需要訪問 flashback_transaction_query 視圖，這個(gè)視圖的 XID 列代表事務(wù)ID，利用這個(gè) ID 可以區(qū)分特定事務(wù)發(fā)生的所有數(shù)據(jù)變化。)