Oracle
1Z0-062 · Question #313
1Z0-062 Question #313: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #313. The question stem and answer options stay visible for context.
Managing Undo Data
Question
Which statement is true about the loss of a data file belonging to the default undo tablespace?
Options
- AThe database remains open in read-only mode.
- BThe database is put in MOUNT state and requires recovery to be opened.
- CThe database remains open for querying but no DML statements can be executed except by the users
- DAll the noncommitted transactions are lost.
- EThe database instance aborts.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#undo tablespace#datafile loss#database states#recovery