Which of these operations will cause a flashback query to fail if it attempts to go back beyond the time when the operation occurred?Choose three answers.
A. ALTER TABLE SHRINK SPACE;
B. ALTER TABLE ADD ( );
C. ALTER TABLE DROP COLUMN ;
D. ALTER TABLE MOVE;
E. CREATE INDEX ON ();

Master Exam中給的答案為：B、C、E

經過試驗，我發現只有C、D兩個選項會導致flashback query fail。
ORA-01466: unable to read data - table definition has changed

Master Exam中答案不正確的題

相關文章