ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-042

043-042

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-05 11:03:06 0 删除 编辑
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要打开行移动。因为重新插入的数据可能占据那个物理地址。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717712/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-041
下一篇: 043-044
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214079