Your database is running in noarchivelog mode.
One of the data files belonging to the system tablespace is corrupted.
You notice that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file?
A.
Shut down the instance if not already shut down, restore all data files belonging to the system
tablespace from the last backup, and restart the instance.
B.
Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
C.
Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
D.
Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
C
D the restoration of the system datafile is done by bringing the database down and in the mount state.
I think C
The correct answer is C. My previous answer is referred to another question. Thank you
Letter C. Considering that database is running in noarchvelog mode, it is not possible that currupted datafile of system tablespace be recovered to current SCN.
C