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 |
What is DCLGEN?
Explain the contents that are a part of dclgen.
What is the connection string to connect to the DB2 Database ?
What is deadlock in db2?
Mention the different locking levels that are available in db2.
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Can we declare DB2 HOST variable in COBOL COPY book?
Name some fields from SQLCA.
What is the difference between CS and RR isolation levels?
Can we insert update delete in view?
how to copy the host variables from ps file into cobol program other than include statement
How can record locking be achieved in those DB2 versions which do not support it?