Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 9308 Views
- Wipro, I also Faced
- E-Mail Answers
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 happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What are the disadvantages of PAGE level lock?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
What is commit in db2?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
How Plan is created while executing the query using SPUFI?
Are views updatable ?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is ibm db2 database?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
db2 restart logic ?
COBOL 
