Master Exam中答案不正確的題

ljm0211發表於2012-06-25
AST
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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11411056/viewspace-733762/，如需轉載，請註明出處，否則將追究法律責任。

相關文章