Contents

Which of the following lock placed by application program?
a) implicit lock    

b) explicit lock
c) exclusive lock 

d) shared lock

b

A type of lock that locks an item from any type of access is known as……….
a) implicit lock    

b) explicit lock
c) exclusive lock

d) shared lock

c

A type of lock that locks an item from change but not from read is known as…
a) implicit lock    

b) explicit lock
c) exclusive lock 

d) shared lock

d

How many levels of lock granularity?
a) one    

b) two    

c) three  

d) four

d

Explanation: row level, page level, table level, database level


Which of the following is known as smallest lock granularity?
a) row level                         

b) page level
c) table level                        

d) database level

a

Which of the following is known as largest lock granularity?
a) row level                          

b) page level
c) table level                        

d) database level

d