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
- 8539 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 |
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What will happen, while trying to close the closed cursor.
What is the format (internal layout) of ?TIMESTAMP??
What keyword does an SQL SELECT statement use for a string search?
Is there any advantage to denormalizing DB2 tables?
Where besides the DB2 catalog is database object information stored by DB2?
How do you do the EXPLAIN of a dynamic SQL statement?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
Give the COBOL definition of a VARCHAR field.
Can we install 2 different versions of Db2 on same mainframe?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
COBOL 
