ITPub博客

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

043-168

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-10 10:36:54 0 删除 编辑
168. You are working on an Oracle Database 10g database that operates
in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table i
n the SYSTEM tablespace that does not belong to the data dictionary w
as dropped at 03:00 p.m. What would you do to recover the table?
A. use the Flashback Transaction Query feature to identify the releva
nt SQL statement and use it to undrop the table
B.restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform. point-in-time recovery to recover the table
Answer: D
对应C 选项,只能在非系统表空间下使用 Flashback Table(利用回收站)
sys 用户下的数据不支持闪回查询
truncate 不支持闪回查询
闪回查询,利用的是undo 空间

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    215408