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.
Answer Posted / hussain
b. the retrieved rows are locked
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
What is copy pending and check pending in db2?
Where can you declare a cursor in a cobol-db2 program?
List out the data types available.
Define db2.
What is a db2 cursor?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Explain about cursor stability?
what is diffrence b/w file-aid tool and file-aid utility???
How would the varchar column remarks defined?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the use of predicate?
What do you mean by storage group (stogroup)?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is sqlca’s maximum length?
What is the difference between nvl and coalesce?