Answer / s

primary key, foreign key, Joins are often performed on
primary and foreign key columns. columns frequently coded
in the WHERE clause, ORDER BY, GROUP BY, DISTINCT, columns
which are searched or joined over less than 5-10% of the
rows.

Explain what are the various isolation levels possible?

0 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What are the contents of a dclmgen?

0 Answers  

---

what is the soft code for deadlock ?

2 Answers   Logica CMG,

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

Can there be more than one cursor open for any program?

0 Answers  

---

What is a page?

2 Answers  

---

What is runstats db2?

0 Answers  

---

How does DB2 use multiple table indexes?

1 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  

---