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 the function of the Data Manager?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
How do I create a view in db2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is lock escalation?
Can we update view in db2?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
Where is the access path logic created by the DB2 Optimizer stored?
What are delete-connected tables?
How do you prepare a COBOL + DB2 program from coading till execution ?
What is dbrm in db2 database?
What does db2 blu stand for?