ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 159

159

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-10 10:03:15 0 删除 编辑
159. You executed the following FLASHBACK TABLE command:
FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi');
Which two statements are correct? (Choose two.)
A. The FLASHBACK TABLE statement will not be written to the alert
log file.
B. The EMP table that was dropped by mistake from the database wi
ll be restored.
C. The changes made to the EMP table since the specified time wil
l be undone.
D. The FLASHBACK TABLE statement will not maintain the existing i
ndexes on the EMP table.
E. The FLASHBACK TABLE statement will be executed within a single
transaction.
F. The list of transactions that have modified the EMP table sinc
e the specified time will be displayed.
Answer: C,E
a、Flashback table 肯定会被写到alert 中
b、使用scn 闪回,肯定是使用的undo 里面的数据,
c、如果一个表被删除后是否还是可以使用闪回表呢(不能)
flashback table test5 to before drop;
d、在一个transaction 中,闪回将被执行
e、闪回表后,同时会恢复在其上的索引

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    202949