ouareinthemiddleofatransactionupdatingaveryimportanttable.Themachineonwhichadatabasewasrunningrebootsbecauseofpoweroutage.Thiscausedadatabaseinstancefailure.Whichstatementistrueinthissituation() A.Theonlineredologfilesandarchivedredologfilesarerequiredtoaccomplishtherecovery.B.Theuncommittedtransactionwillbecommittedatthenextstartupofthedatabaseinstance.C.Theuncommittedtransactionisrolledbackautomaticallyatthenextopeningofthedatabase.D.TheDBAhastoperformtherecoveryonthedatabasetorecovertheuncommittedtransaction.
ouareinthemiddleofatransactionupdatingaveryimportanttable.Themachineonwhichadatabasewasrunningrebootsbecauseofpoweroutage.Thiscausedadatabaseinstancefailure.Whichstatementistrueinthissituation()
A.Theonlineredologfilesandarchivedredologfilesarerequiredtoaccomplishtherecovery.
B.Theuncommittedtransactionwillbecommittedatthenextstartupofthedatabaseinstance.
C.Theuncommittedtransactionisrolledbackautomaticallyatthenextopeningofthedatabase.
D.TheDBAhastoperformtherecoveryonthedatabasetorecovertheuncommittedtransaction.