Write two to three paragraphs answering one of the following questions: 

  • What is concurrency control? How are locks and schedulers used to resolve concurrency conflicts?
  • What is the difference between a rule-based optimizer and a cost-based optimizer?

Be sure to cite your references. 


TOP – Write your guess in your own words at the top.

BOTTOM – Write the right answer in your own words at the bottom.