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
  13% (3)
• B
  8% (2)
• C
  71% (17)
• D
  4% (1)
• E
  4% (1)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces008.htm

No community discussion yet for this question.