What is denormalization and when would you go for it?

9 Answers   NBP,

---

What is a join and explain different types of joins?

2 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

What is dbms and its application?

0 Answers  

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,

---

Write the fastest query to find out how many rows exist in a table?

0 Answers  

---

State the acid rules?

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

What is an application role and explain a scenario when you would use one?

0 Answers  

---

Explain about xml databases?

0 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

---

Can you have a nested transaction?

1 Answers  

---