B, D, E
B: Undo tablespace is typically locked in read-only mode. Using temp undo allows DML operations to occur on global temporary tables even in a read-only database
D: By using temp UNDO, the system avoids unnecessary writes to SYSTEM tablespace, which improves performance by reducing I/O operations
E: Usage of UNDO space in the UNDO tablespace is minimized since the UNDO for DML operations is stored in temporary storage
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
cf1f99b
1 month agoEddieY
2 weeks, 1 day ago