In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

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.

0 Answers  

---

Which command is used to remove all rows from a table?

0 Answers  

---

what is static sql? what is dynamic sql? Give me details

3 Answers  

---

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

What are the various locks available?

5 Answers   CTS,

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

What is dclgen (declaration generator)?

0 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---