Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

Question

Options

• AAn undo segment may be used by multiple transactions simultaneously
• BUndo segments can wrap around to the first extent when a transaction fills the last extend of the
• CUndo segments have a minimum of three extents
• DUndo segments can extend when a transaction fills the last extent of the undo segment
• EA single transaction may use multiple undo segments simultaneously
• FUndo segments must be stored in a BIGFILE tablespace
• GUndo segments must be stored in a SMALLFILE tablespace

• A
  80% (35)
• B
  2% (1)
• C
  2% (1)
• E
  11% (5)
• F
  5% (2)

No community discussion yet for this question.