Which statement is true?

In the SPFILE, UNDOJTABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

In the SPFILE, UNDOJTABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

A.
The tablespace will be renamed but the data file headers will not be updated.

B.
The statement will fail because you cannot rename an undo tablespace.

C.
The tablespace will be renamed and all the changes will be logged in the alert log.

D.
The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

E.
You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.



Leave a Reply 0

Your email address will not be published. Required fields are marked *