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 206 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
YES! Correct, THANKS for helping me on my review


upturnedfurball

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Excellent

 

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

For a complete list of videos, visit our video library