Which of these is true about undo tablespace?
A.
Undo tablespace is a temporary tablespace
B.
Undo tablespace has only one datafile
C.
Undotablespace has a datafile which is reused in cyclic manner
Which of these is true about undo tablespace?
Which of these is true about undo tablespace?
The corect answer is – Undotablespace has a datafile which is reused in cyclic manner
Read this : https://forums.oracle.com/thread/2496998
Undo tablespace is not a temporary tablespacs
is a type of permantet tablespace used by oracle database
c is correct.what do you think?..
No doubt C is the right answers.
None of these are correct. About C this is not the datafile which is used in a cyclic manner but the undo segments.
Extract from Oracle document (http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT89184):
Conceptually, the extents in an undo segment form a ring. Transactions write to one undo extent, and then to the next extent in the ring, and so on in cyclical fashion.
What’s correct?
undo tablespace is not temporary tablespace