Oracle
1Z0-067 · Question #9
1Z0-067 Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
Question
In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. You rename the undotbs undo tablespace: ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is true?
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
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.