To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

0 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

How you can make a parameterized view?

0 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---

Explain what a database is?

0 Answers  

---

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

0 Answers  

---

What are the types of database model?

0 Answers  

---

What are triggers? How many triggers you can have on a table?

2 Answers   Ramco,

---

I have a few records all are same structures data, I want to store data in multiple targets how

0 Answers   CTR, Infosys, Polaris,

---

can you give me the syntax of named procedure??

2 Answers  

---