Answer / sunil1405

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

What is runstats and reorg in db2?

0 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

Name the various locking levels available?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

List out the three types of page locks that can be held.

0 Answers  

---

How to design maps

1 Answers   Virtusa,

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

What is the size of a data page?

2 Answers   IBM,

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

How to create a table using embedded sql?

1 Answers  

---

What is sqlcode -922 ?

2 Answers  

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---