Due to media failure you lost one of the data files belonging to the USERS tablespace, and the
tablespace is not available to use. Which statement regarding the status of the database is true?
A.
The database remains open.
B.
The database gets dismounted.
C.
The database becomes read only.
D.
The database instance gets aborted.
E.
The database gets shut down automatically.
F.
The status of the database depends on the status of the USERS tablespace.
If either a permanent or temporary media failure affects any datafiles of a database operating in NOARCHIVELOG mode, then the database automatically shuts down.
https://web.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/recoscen.htm
So A may not be correct all the time…
As in Windows OS, if a win datafile is missing, will not necessarily shut down the database