You need to rename a data file of a tablespace.
How would you perform this?
A.
bring the database to the NOMOUNT state, rename the data file using the operating system, and then execute the:
ALTER TABLESPACE … RENAME DATAFILE … statement
B.
take the tablespace that contains the data file offline, rename the data file using the operating system, execute the:
ALTER DATABASE … RENAME DATAFILE … statement, and bring the tablespace online
C.
take the tablespace that contains the data file offline, rename the data file using the operating system, execute the:
ALTER TABLESPACE … RENAME DATAFILE … statement, and bring the tablespace online
D.
make the tablespace that contains the data file read only, rename the data file using the operating system, execute the:
ALTER TABLESPACE … RENAME DATAFILE … statement to rename the data file, and make the tablespace read/write