You need to rename a data file of a tablespace. How would you perform this?
A.
make the tablespace that contains the data file read only, rename the data file
using the operating system, execute the ALTERTABLESPACE… RENAME DATAFILE
.. statement to rename the data file, and make the tablespace read/write
B.
bring the database to the NOMOUNT state, rename the data file using the
operating system, and then execute the ALTER TABLESPACE…RENAME DATAFILE
.. statement
C.
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
D.
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