What are the different levels of lock granuality?
Answer to relevant QuestionsWhy might a page-level lock be preferred over a field-level lock?What are the three types of database critical events that can trigger the database recovery process? Give some examples for each one.Assuming that pessimistic locking is being used, but the two-phase locking protocol is not, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the complete ...Suppose you are asked to evaluate a DBMS in terms of lock granularity and the different locking levels. Create a simple database environment in which these features would be important.What are some general guidelines for creating and using indexes?
Post your question