试题详情
多项选择题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

  • 关注下方微信公众号，在线模考后查看

热门试题