Oracle Database 12c Advance Adminstration1z0-063 Test 1

Question : 24 of 40

Marks: +1, -0

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

The tablespace will be renamed but the data file headers will not be updated.
The statement will fail because you cannot rename an undo tablespace.
The tablespace will be renamed and all the changes will be logged in the alert log.
The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Validate

Go to Question:

Prev Question

Next Question