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

Question

Options

• AThe tablespace will be renamed but the data file headers will not be updated.
• BThe statement will fail because you cannot rename an undo tablespace.
• CThe tablespace will be renamed and all the changes will be logged in the alert log.
• DThe tablespace will be renamed and a message written to the alert log indicating that you should
• EYou must set the undo_tablespace parameter to some other tablespace name before renaming

• A
  12% (4)
• B
  6% (2)
• C
  76% (26)
• D
  3% (1)
• E
  3% (1)

No community discussion yet for this question.