What are the various locking levels available?

Answers were Sorted based on User's Feedback



What are the various locking levels available?..

Answer / s

TABLESPACE,TABLE, PAGE,ROW

Is This Answer Correct ?    10 Yes 0 No

What are the various locking levels available?..

Answer / sadiq afroze

PAGE, TABLE, TABLESPACE

Is This Answer Correct ?    0 Yes 2 No

What are the various locking levels available?..

Answer / ram

Cursor Stability, Read Stability, Uncommited Read and Repeatable Read

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is bind plan?

0 Answers  


What is nvl in db2?

0 Answers  


How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,


how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,


define clustering index.

0 Answers  






On which levels locks can be applied?

0 Answers  


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


What are common abends

1 Answers   SPIC, Virtusa,


How could one combine a set of incremental image copies into a single copy?

1 Answers  


Explain about dbrm.

0 Answers  


For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


Categories