大數(shù)據(jù)就業(yè)實(shí)戰(zhàn)培訓(xùn) Oracle就業(yè)實(shí)戰(zhàn)培訓(xùn)
OCP 19c 1Z0-083認(rèn)證考試題庫（第5題）-CUUG內(nèi)部學(xué)員版083題庫解析
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ù)庫版本，但是在當(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ù)變化。)
CUUG與ORACLE公司建立最核心、最權(quán)威、最深層次的戰(zhàn)略合作伙伴關(guān)系；
CUUG是唯一一家只做DBA就業(yè)培訓(xùn)和oracle認(rèn)證的授權(quán)機(jī)構(gòu)，28年培養(yǎng)數(shù)萬名oracle技術(shù)人才；
CUUG金牌講師授課，來自一線的資深ORACLE OCM技術(shù)專家團(tuán)隊(duì)；
CUUG頂尖完善的學(xué)習(xí)體系，以甲骨文原廠ORACLE數(shù)據(jù)庫核心技術(shù)為教學(xué)課程；