nerdexam
Oracle

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.

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.

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    71% (20)
  • C
    7% (2)
  • D
    4% (1)
  • E
    14% (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.

AThe database remains open in read-only mode.

The database cannot remain open, even in read-only mode, without its default undo tablespace because it cannot ensure consistent reads or transaction integrity.

BThe database is put in MOUNT state and requires recovery to be opened.Correct

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.

CThe database remains open for querying but no DML statements can be executed except by the users

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.

DAll the noncommitted transactions are lost.

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.

EThe database instance aborts.

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

#undo tablespace#datafile loss#database states#recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice