MCQs > IT & Programming > Oracle 9i Administration > You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are still transactions using UNDO_TBS1: ALTER SYSTEM SET UNDO_TABLESPACE = undo_tbs2 What will be the result?

Oracle 9i Administration MCQs

You have two undo tablespaces defined for your database. The instance is currently using the undo tablespace named UNDO_TBS1. You issue the following command to switch to UNDO_TBS2, while there are still transactions using UNDO_TBS1:

ALTER SYSTEM SET UNDO_TABLESPACE = undo_tbs2

What will be the result?


Answer

Correct Answer: New transactions are assigned to UNDO_TBS2

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle 9i Administration Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Oracle 9i Administration Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it