1Z0-062 · Question #313
Which statement is true about the loss of a data file belonging to the default undo tablespace?
The correct answer is B. The database is put in MOUNT state and requires recovery to be opened. The loss of a data file belonging to the default undo tablespace is a critical issue that prevents the database from guaranteeing transaction integrity and requires database recovery.
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.
How the community answered
(28 responses)- A4% (1)
- B71% (20)
- C7% (2)
- D4% (1)
- E14% (4)
Why each option
The loss of a data file belonging to the default undo tablespace is a critical issue that prevents the database from guaranteeing transaction integrity and requires database recovery.
The database cannot remain open, even in read-only mode, without its default undo tablespace because it cannot ensure consistent reads or transaction integrity.
If a data file for the default undo tablespace is lost, the database cannot perform rollbacks or ensure read consistency, leading to an unopenable state from which it can only be recovered after being placed in MOUNT state.
Without a functional undo tablespace, no DML operations can be executed, and even querying might yield inconsistent results, rendering the database inoperable for normal use.
While noncommitted transactions will be lost due to the absence of their undo information, this statement describes a consequence rather than the specific state of the database itself.
Although the instance might abort, the database's ultimate state preventing it from being opened and necessitating recovery is the MOUNT state, which allows for recovery operations to be performed.
Concept tested: Oracle database recovery and undo tablespace criticality
Source: https://docs.oracle.com/en/database/oracle/oracle-database/21/admin/overview-of-backup-and-recovery.html
Topics
Community Discussion
No community discussion yet for this question.