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.
Answers were Sorted based on User's Feedback
a. none of the rows are locked.
Thanks;
Amita Sharma.
Is This Answer Correct ? | 8 Yes | 1 No |
If I have a view which is a join of two or more tables, can this view be updateable?
What DB2 Catalog column tell you when an index needs table reorganized ?
How can you get the number of rows impacted by the last executed query?
What is the picture clause of null indicator variable?
how do you resolve -805?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is difference between rollback and commit?
Explain about cursor stability?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
How do you Load a table ?? and what is Load replace ?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
What is page size in db2?