How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

what are extents?

5 Answers  

---

What is a db2 schema?

0 Answers  

---

When do you specify the isolation level?

0 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

---

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

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  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

What is the latest version of ibm db2?

0 Answers  

---

How many buffer pools are there in DB2?

2 Answers  

---