You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?()
- A、Event Viewer gives more details on the failure.
- B、The alert log file gives detailed information about the failure.
- C、PMON rolls back the transaction and releases the locks.
- D、SMON rolls back the transaction and releases the locks.
- E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
- F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
正确答案:C,F
答案解析:有
微信扫一扫手机做题