What is the difference between drop table and delete table?

0 Answers  

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

What is sqlcode -922 ?

2 Answers  

---

What is a DBRM, PLAN ?

3 Answers  

---

When do you specify the isolation level? How?

1 Answers  

---

What is meant by explain?

0 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

what is rebinding ?

1 Answers   IBM,

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

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,

---