Answer / s

CREATE TABLE AAA
LIKE TABLE BBB;

Answer / nag(igate)

the like will create the same table structure and it will
not copy data from existing table.

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

What is ibm db2 client?

0 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

Explain various types of locks in db2?

0 Answers  

---

What is a recovery log?

1 Answers  

---

What is a synonym? How is it used?

2 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

what is the difference between join and union?

4 Answers   IBM,

---

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,

---

What do you mean by rollback?

0 Answers  

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---