42. Exhibit
A user has inserted wrong department data in the DEPT3 table in the U
SERS tablespace. You use the Flashback Table functionality to rectify
the erroneous inserts. While performing the recovery, you choose 200
4343 as the Flashback SCN.
Which two statements are correct in this scenario? (Choose two.)
A. Only the row with DEPARTMENT_ID 290 would be flashed back.
B. The rows with DEPARTMENT_ID 290 and 300 would be flashed back.
C. The rows with DEPARTMENT_ID 290 and 280 would be flashed back.
D. You would have taken the USERS tablespace offline before starting
the Flashback Table operation.
E. You would have enabled row movement for the DEPT3 table before sta
rting the Flashback Table operation.
Answer: C, E
闪回表到某个scn要打开行移动。因为重新插入的数据可能占据那个物理地址。
闪回表到某个scn要打开行移动。因为重新插入的数据可能占据那个物理地址。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717712/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
