Which statement is true about the loss of a data file b…

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

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

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *