Redo log files are used to roll back uncommitted transactions???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Redo log files are used to roll back uncommitted transactions???

  1. #1
    Join Date
    Aug 2002
    Location
    Brighton, England
    Posts
    93

    Redo log files are used to roll back uncommitted transactions???

    Which two statements concerning redo log files are true? (Choose two.)
    1.Redo log files store committed changes to the database.
    2.Redo log files are used to roll back uncommitted transactions.
    3.Only one redo log file is required.
    4.Changes are written to the redo log files when the redo log buffer is 3/4 full.
    5.Redo log files are used instead of archiving for point-in-time recovery.

    Apparently 1&2 are correct. But How can 2 be correct I don't understand

    Cheers
    Gus

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width