Multiple choice technology databases

Rollback transaction data is stored in which data file.

  1. System

  2. Sysaux

  3. Undo

  4. Index
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Rollback transaction data is stored in Undo data files (or Undo tablespace) in Oracle. This undo information is used to rollback transactions, provide read consistency, and enable Flashback features. System (A) tablespace contains data dictionary, Sysaux (B) contains auxiliary data, and Index (D) files store indexes - not transaction rollback data.

Keep practicing — related questions