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 difference between Static call and Dynamic call? How does it function?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
How to handle null values in db2
what is cursor stability?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
How do you do the EXPLAIN of a dynamic SQL statement?
how to fetch multiple records without using cursor
what is plan? is plan executable or package?
how can i pull up a query which was previously stored in qmf
How to see the structure of db2 table??
what are the bind parameters?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?