ITPub博客

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

043-165

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-10 10:31:36 0 删除 编辑
165. You have only two redo log groups and these groups get overwritt
en several times in a day. Your database operates in NOARCHIVELOG mod
e and user-managed consistent backups are performed every Sunday nigh
t. On Thursday morning, you find that an important table has been dro
pped and purged. With reference to this scenario, up to what point in
time can the data be recovered?
A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday's backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening
Answer: D
日志组有限,数据库处于非归档模式,数据库一旦出现问题,那么只能恢复
到最后一次完整备份。如果没有做备份,那你就惨了!

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    202914