Oracle Exam 1Z0-497 Topic 2 Question 48 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 48
Topic #: 2

You are in the middle of transaction, updating a table. The machine on which the database is running reboots because of a power outage. This causes a database instance failure.

Which statement is true in this situation?

AThe online redo log files and archived redo log files are required to accomplish a recovery.

BThe uncommitted transaction is committed at the next startup of the database instance.

CThe uncommitted transaction is rolled back automatically at the next opening of the database.

DThe DBA has to perform a recovery on the database to recover the uncommitted transaction.

Show Suggested Answer

Suggested Answer: C

by Kimbery at May 09, 2022, 11:05 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!