This topic contains a solution. Click here to go to the answer

Author Question: In Oracle Database recovery facilities, OnLine ReDo files are backup log files maintained separately ... (Read 209 times)

leo leo

  • Hero Member
  • *****
  • Posts: 566
In Oracle Database recovery facilities, OnLine ReDo files are backup log files maintained separately and not necessarily on disk media.
 
  Indicate whether the statement is true or false

Question 2

Briefly define the four isolation levels and the problems they prevent.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

dyrone

  • Sr. Member
  • ****
  • Posts: 322
Answer to Question 1

FALSE

Answer to Question 2

The four isolation levels are read uncommitted, read committed, repeatable read and serializable. The three problems that can occur because of concurrent processing are dirty reads, nonrepeatable reads, and phantom reads. The read uncommitted isolation level does not prevent any of these problems from occurring. The read committed isolation level prevents dirty reads. The repeatable read isolation level prevents dirty reads and nonrepeatable reads. The serializable isolation level prevents all three problems from occurring.




leo leo

  • Member
  • Posts: 566
Reply 2 on: Jul 7, 2018
Wow, this really help


AngeliqueG

  • Member
  • Posts: 343
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

Blood is approximately twice as thick as water because of the cells and other components found in it.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

The eye muscles are the most active muscles in the whole body. The external muscles that move the eyes are the strongest muscles in the human body for the job they have to do. They are 100 times more powerful than they need to be.

For a complete list of videos, visit our video library