Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vishal the expert
The level and type of information that the lock protects is
called locking granularity. Locking granularity affects
performance. When a user cannot access a row or key, the
user can wait for another user to unlock the row or key. If
a user locks an entire page, a higher probability exists
that more users will wait for a row in the page. The
ability of more than one user to access a set of rows is
called concurrency. The goal of the database administrator
is to increase concurrency to increase total performance
without sacrificing performance for an individual user.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is 32 gigs of ram overkill?
What are the different functions of an operating system?
What is memory-management unit (mmu)?
What is NOS?
Can I have two browsers on my computer?
Explain turnaround time and response time?
Considering notepad/IE or any other thing as process, What will happen if you start notepad or IE 3 times ? Where three processes are started or three threads are started?
What are loosely coupled systems?
Tell me if you know how are the wait/signal operations for monitor different from those for semaphores?
Explain the purpose of the open() and close() operations.
What are different types of interprocess communication methods?
What is a phase change memory?
What are the 3 categories of operating systems?
What is a virtual memory?
Can x86 run 64 bit?
