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
- 9332 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 is a precompiler?
On the create tablespace, what does the CLOSE parameter do?
How to check sequence on a table in db2?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is a predicate?
What is the role of data manager in the db2 database?
What are the functions of Bind?
my project is insurance management system,how to explain my work environment in interview?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What can the Locate option of the Repair Utility accomplish?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
COBOL 
