Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

What is cascading rollback?

1 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

Explain about cursor stability?

1 Answers  

---

How to check last update on table in db2?

1 Answers  

---

What is the reason behind not using select * in embedded sql programs?

1 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1 Answers   IBM,

---

What are the disadvantages of PAGE level lock?

3 Answers  

---

Name the lockable units in DB2?

1 Answers  

---

What does DML stand for and what are some examples of it?

3 Answers   IBM,

---

Mention the downsides of page level lock.

1 Answers  

---

What is deadlock?

2 Answers  

---