問題文
An instance is brought up on a database whose undo tablespace has been dropped by mistake, and a second attempt names a tablespace that was never created. Which statement about the two attempts is correct?
選択肢
- Both attempts come up and the undo goes into the tablespace that holds the dictionary in each of them, because a name that matches nothing is treated in the same way as a database that has been left without any such tablespace at all.
- Both attempts fail and the log of events records the same reason for each of them, because a place for the undo has to be present and named before an instance is able to reach the state in which the callers connect to it.
- The first attempt does not come up because a database is unable to open without a place for the undo it makes, while the second attempt comes up and falls back upon the tablespace that holds the dictionary for as long as the name is unknown.
- The first attempt comes up and puts the undo it makes into the tablespace that holds the dictionary and leaves a warning in the log of events, while the second attempt does not come up at all because the name it was handed matches nothing.