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
Give a brief description of the following terms: a) Play head b) Symbol c) Tweening d) ActionScript e) Frame rate f) Library panel g) Masking h) Context – sensitive Property Inspector i) Bandwidth Profiler j) Frame Label
What is multi tasking, multi programming and multi threading?
What is turnaround time?
Differentiate between pre-emptive and non-pre-emptive scheduling.
What does the 400 mhz signify in a ram specification?
Explain about Different types of real-time scheduling?
What is throughput?
Which one you will use to implement critical section?
Tell me what is executive in windows nt?
What is operating system in computer?
What is synchronization? What are the different synchronization mechanisms?
What are types of operating system?
What is a long term scheduler & short term schedulers?
Explain the command rate in reference to ram?
What is the Difference between Loading and Linking ?