ITPub博客

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

043-061

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-06 11:15:44 0 删除 编辑
61. You are working in an online transaction processing (OLTP) enviro
nment. You realize that the salary for an employee, John, has been ac
cidentally modified in the EMPLOYEES table. Two days ago, the data wa
s in the correct state. Flashback logs generated during last two days
are available in the flash recovery area. Which option would you cho
ose to bring the data to the correct state while ensuring that no oth
er data in the same table is affected?
A. perform. point-in-time recovery
B. perform. a Flashback Table operation to restore the table to the st
ate it was in two days ago
C. perform. a Flashback Database operation to restore the database to
the state it was in two days ago
D. perform. Flashback Versions Query and Flashback Transaction Query t
o determine all the necessary undo SQL statements, and then use them
for recovery
Answer: D
Flashback Query 只能看到某一点的对象状态,Flashback Version Query 可以
看到过去某个时间段内,记录的演变历史。
(快速定位,因为是错误的修改表记录,只能闪回查询)

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214087