Oracle 11G OCP 1Z0-053 215

(215)Which two statements regarding the Flashback Table feature are correct?(Choose two.)

A. Flashback Table can be performed on system tables.

B. Flashback Table operation does not shrink the segments.

C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.


答案:(B、D)

解析:

A(X),不能对系统表、远程表和fixed table 执行闪回表操作

C(X),闪回表操作使用undo还原数据,不需要用logminer来挖掘redo_sql和undo_sql

请使用浏览器的分享功能分享到微信等