ITPub博客

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

043-111

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-08 09:45:53 0 删除 编辑
111. You are working in an online transaction processing (OLTP) envir
onment. You used the FLASHBACK TABLE command to flash back the CUSTOM
ERS table. Before executing the FLASHBACK TABLE command, the System C
hange Number (SCN) was 663571. After flashing back the CUSTOMERS tabl
e, you realize that the table is not in the correct state and the res
ultant changes are not what you had desired. So, you need to reverse
the effects of the FLASHBACK TABLE command while ensuring that:
a) No other user data in the database is affected.
b) The operation takes the minimum possible time
Which option would you choose?
A. Use ROLLBACK command with SCN 663571.
B. Perform. Flashback Transaction Query with SCN 663571.
C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS
table as it was at SCN 663571.
D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMER
S table as it was at SCN 663571.
Answer: D
Flashback table 后发现数据不对,提出要求一是不影响其它数据二是要快,
那么再闪回一次就行了

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203403