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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
C is wrong: yes, you can’t execute DML but “except by the users with sysdba privs” has no sense.
I think E rarely the instance can remain open but you should run shutdown abort for starting a recover