ITPub博客

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

043-090

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-07 20:20:37 0 删除 编辑
90. You are working on an Oracle Database 10g database. For which pur
poses would you use the Flashback Transaction Query feature? (Choose
all that apply)
A. To recover a dropped table.
B. To recover a dropped schema.
C. To recover data from a truncated table.
D. To view changes made by all the transactions during a given period
of time.
E. To view changes made by a single transaction during a given period
of time.
Answer: D, E
查看视图,每个事务都对应相同的XID.
Sql>select xid,operation,commit_scn,undo_sql
From flashback_transaction_query
Where xid in(select version_xid from tmp1 where versions between scn
minvalue and maxvalue);

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203100