Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locks available?
- 5 Answers
- 12359 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmisudha
locks are 2 types
1.explicet locks
cs,rr,ur,rs
2.implicet locks
shared,exclusive,update
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nag(igate)
They are the 3 types of locks
1.Mode:share,exclusive,update intent
2.Size:tablespace,table,page,row
3.Duration: Acquire,release
| Is This Answer Correct ? | 1 Yes | 1 No |
what's the error code for Unique Index Violation?
What is a synonym? How is it used?
What is blu acceleration in db2?
What is the difference between nvl and coalesce?
what is the soft code for deadlock ?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
What is db2 instance?
Which component is used to execute the sql statements?
When would you prefer to use VARCHAR?
List down the data types in the db2 database.
How to execute stored procedure in db2 command editor?
Where can you declare a cursor in a cobol-db2 program?
COBOL 
