Answer Posted / s
Isolation level determines how long the page or row locks
will be held.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Is the primary key a clustered index?
Which component is responsible for processing sql statements and selecting access paths?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Explain the function of data manager.
How do you select a row using indexes in db2?
what is db2 restart?
What is a db2 cursor?
List some fields from sqlca?
How to restart a DB2 program?
Which isolation level provides highest data integrity?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is package in db2 mainframe?
How to fetch the last row from the table in SQL (db2)?