In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.You rename the undotbs undo tablespace:ALTER TABLESPACE undotbs RENAME

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.You rename the undotbs undo tablespace:ALTER TABLESPACE undotbs RENAME

Post by answerhappygod »

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?

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply