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 错