ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Operating Systems  >>  Operating Systems General Concepts
 
 


 

 
 Windows interview questions  Windows Interview Questions
 Linux interview questions  Linux Interview Questions
 Unix interview questions  Unix Interview Questions
 Solaris interview questions  Solaris Interview Questions
 RTOS interview questions  RTOS Interview Questions
 Bulnex interview questions  Bulnex Interview Questions
 Operating Systems General Concepts interview questions  Operating Systems General Concepts Interview Questions
 Data Structures interview questions  Data Structures Interview Questions
 Operating Systems AllOther interview questions  Operating Systems AllOther Interview Questions
Question
What is lock granularity?
 Question Submitted By :: Rukhsaar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is lock granularity?
Answer
# 1
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 ?    0 Yes 0 No
Vishal The Expert
 

 
 
 
Other Operating Systems General Concepts Interview Questions
 
  Question Asked @ Answers
 
What is the difference between primary & secondary storage device?  3
Differentiate between compiler and interpreter?  1
Term stickily bit is related to a)kernel b)undeletable file c)none Siemens2
What are the impact on network when gc,schema master,domainnaming master,rid master,pdc emulator,infrastructure master is down? HCL1
What is cache memory?  1
Advantage of SRAM over DRAM ? Hughes1
Differentiate between ROM and RAM? Sutherland2
what is disk interleaving? why is disk interleaving adopted? IBM1
How to communicate between difference process? HP2
for an application which exceeds 64k the memory model should be a)medium b)huge c)large d)none  1
Differentiate between Complier and Interpreter?  1
In loading programs into memory, what is the difference between load-time dynamic linking and run-time dynamic linking?  1
A 12 address lines maps to the memory of [a] 1k bytes [b] 0.5k bytes [c] 2k bytes [d] none Wipro3
unix system is a)multi processing b)multi processing ,multiuser c)multi processing ,multiuser,multitasking d)multiuser,multitasking eInfochips1
What are the stipulations of C2 level security?  1
What are rings in Windows NT?  1
What is meant by arm-stickiness?  1
What is the difference between mutex and semaphore? HP4
What is the best suited algorithm to avoid internal fragmentation? HP1
what is the difference btn collision domain and broad cast domain?  2
 
For more Operating Systems General Concepts Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com