Question: 1, If you were updating a database using an overnight batch process and did not require access to the database by other users during this

1, If you were updating a database using an overnight batch process and did not require access to the database by other users during this process, which locking level would you use and why?

2. If you have a database where the access pattern is predominately read with very few updates, would you use optimistic or pessimistic locking? Describe why.

3. What is the difference between "roll forward" and "roll backward" recovery?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Using the case study below: Memo to the Project Sponsor. In the memo, outline the following: a. Recommendations for managing the project - should leverage the scope management plan and scope...

ANSWER QUESTIONS 1. What are the five activities of systems analysis, and which activity is discussed beginning with this chapter? 2. What is a user story? What is a use case? 3. What are the two...

ANSWER QUESTIONS 11. What is an elementary business process (EBP)? 12. Explain how the event decomposition technique helps identify use cases at the right level of analysis. 13. What is an event? 14....

ANSWER QUESTIONS 1. What are the five activities of systems analysis, and which activity is discussed beginning with this chapter? 2. What is a user story? What is a use case? 3. What are the two...

ANSWER QUESTIONS 16. Define a temporal event and give an example that applies to a checking account system. 17. What are system controls, and why are they not considered part of the users' functional...

ANSWER QUESTIONS 21. What is UML? 22. What is the purpose of UML use case diagrams? 23. What is another name for "actor" in UML, and how is it represented on a use case diagram? 24. What is the...

Using the case study below: Analyse the project from your own perspective as an up-and-coming project manager Devise a set of subsidiary Project Management plans for Schedule and Cost based on the...

Using the case study below: Analyse the project from your own perspective as an up-and-coming project manager Devise a Schedule Project Management Plan and Cost Project Management Plan based on the...

Suppose there are 5 types of toys, which you are collecting one by one, with the goal of getting a complete set. When collecting toys, the toy types are random (as is sometimes the case, for example,...

CPAs R Us conducts CPA review courses. Public universities that permit free use of a classroom support the classes. The only major expense incurred by CPAs R Us is the salary of instructors, which is...

Identify the synergies and conduct a sensuality analysis into estimate

Suppose the following bond quote for IOU Corporation appears in the financial page of today's newspaper. Assume the bond has a face value of $ 1 , 0 0 0 and the current date is April 1 5 , 2 0 2 2 ....

How can Federal jobs in the same GS Pay Grade be considered jobs of Comparable Worth?

What is the Salary Range Midpoint and how does it relate to the Pay Policy Line? For which analytic is it important?

How wide are Salary Structure Ranges?