• 052-62


    You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
    Which statement is true in this situation?

    A.The online redo log files and archived redo log files are required to accomplish the recovery.
    B.The uncommitted transaction will be committed at the next startup of the database instance.
    C.The uncommitted transaction is rolled back automatically at the next opening of the database.
    D.The DBA has to perform the recovery on the database to recover the uncommitted transaction.

    完成恢复只需要联机重做日志,不需要归档日志,所以 A 错
    下一次启动实例的时候会将位提交的事务回滚而不是提交,B 错,C 对
    实例恢复由 SMON 自动执行,而不是 DBA 控制,D 错

  • 相关阅读:
    周总结(第十一周)
    周总结(第十周)
    周总结(第九周)
    周总结(第八周)
    周总结(第七周)
    周总结(第六周)
    周总结(第5周)
    周总结(第四周)
    周记
    补周记
  • 原文地址:https://www.cnblogs.com/Babylon/p/8000374.html
Copyright © 2020-2023  润新知