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?

Oracle is designed to isolate failures at the tablespace or datafile level. When a media failure affects a non-SYSTEM, non-UNDO tablespace like USERS, Oracle marks the affected datafile offline and the tablespace becomes unavailable, but the database instance itself continues running. Only failures involving the SYSTEM tablespace or active undo segments force the instance to abort.

Dismounting would remove the database's association with its control file, which does not occur from a single datafile media failure in a non-critical tablespace.

Read-only mode is an administrative state set explicitly by a DBA; it is not triggered automatically by a media failure.

Instance abort (ABORT) occurs from internal errors or SYSTEM/UNDO failures, not from a lost USERS datafile.

Automatic shutdown is not triggered by a non-SYSTEM, non-UNDO tablespace failure; Oracle keeps the instance running to allow recovery actions.

The USERS tablespace status affects only access to its data; it does not conditionally determine whether the database itself remains open or closes.