Oracle Database 12c: Installation and Administration — Question 33

Which statement is true about the loss of a data file belonging to the default undo tablespace?

Answer options

• A. The database remains open in read-only mode.
• B. The database is put in MOUNT state and requires recovery to be opened.
• C. The database remains open for querying but no DML statements can be executed except by the users with SYSDBA privilege.
• D. All the noncommitted transactions are lost.
• E. The database instance aborts.

Correct answer: C

Explanation

When a data file from the default undo tablespace is lost, the database remains open for querying, but only users with SYSDBA privileges can perform Data Manipulation Language (DML) operations. Other options are incorrect because the database does not go into read-only mode, does not require recovery just to open, does not abort, and does not automatically lose all uncommitted transactions.