Assuming that pessimistic locking with the two-phase locking protocol is being used create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the complete processing of the transaction described in Problem.
Answer to relevant QuestionsWrite the SQL statements that might be used in transaction management and explain how they work.What DBMS component is responsible for concurrency control? How is this feature used to resolve conflicts?What are optimizer hints and how are they used?Should you create an index? If so, what would the index column(s) be, and why should you create that index?What index would you recommend, and what command would you use?
Post your question