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 208 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


Laurenleakan

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

 

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

For a complete list of videos, visit our video library