What are the disadvantages of PAGE level lock ?
High resource utilization if large updates are to be done
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Explain MySQL locks. 07.01.09
Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as t...What is a deadlock and what is a live lock? How will you go about resolving deadlocks? 09.05.08
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait i...What is meant by isolation level ? 03.04.08
This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 're...What is an intent lock ? 02.04.08
An intent lock is at the table level for a segmented tablespace or at the tablespace level for a non-segmented tablespace. They indicate at the table or table...What is lock escalation ? 14.03.08
Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has aquired more locks than specified in NUMLKTS. Locks should be taken on obje...How does DB2 determine what lock-size to use? 14.03.08
There are three methods to determine the lock-size. They are: 1. Based on the lock-size given while creating the tablespace 2. Programmer can direct the DB2...I use CS and update a page. Will the lock be released after I am done with that page ? 14.03.08
No....What is lock escalation? 15.06.06
Lock escalation is the process of converting a lot of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a m...What are the advantages and disadvantages of viewstate? 14.03.06
The primary advantages of the ViewState feature in ASP.NET are: 1. Simplicity. There is no need to write possibly complex code to store form data between page...What happens when a thread cannot acquire a lock on an object? 07.03.06
If a thread attempts to execute a synchronized method or synchronized statement and is unable to acquire an object's lock, it enters the waiting state until the...