Answer / Nitin Verma

When converting IDMS to DB2, dealing with occurs and redefined clauses can be handled as follows:
1. Identify the tables containing occurs and redefined clauses.
2. Use a tool like CA's Databridge or IBM's Data Studio to convert these tables.
3. In the conversion process, the tool will create additional tables to handle recursive dependencies.
4. After conversion, you may need to manually modify the applications to point to the new table structures.

what is Normalization?

6 Answers   TCS,

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

State the acid rules?

1 Answers  

---

What are the key features of dbms?

1 Answers  

---

fact table and dimension table containg one to many relationship or many to one relastionship

1 Answers  

---

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

1 Answers  

---

In which database can extended stored procedures be added?

1 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

What is a join and explain different types of joins?

2 Answers  

---

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

1 Answers  

---

Explain the family trees and connection by clause.

1 Answers  

---