Answer / Vinod Kumar Nimesh

A fact table typically contains measures (facts) and has a one-to-many relationship with its associated dimension tables. In a many-to-one relationship, a single fact can belong to multiple dimensions, but each dimension contains only one fact.

What is database design and development?

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  

---

What is a join and explain different types of joins?

2 Answers  

---

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

1 Answers  

---

How would you design a database for an online site, which would average a million hits a day?

1 Answers  

---

Who are naive users?

1 Answers  

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1 Answers  

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1 Answers  

---

Explain about the database management systems.

1 Answers  

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

In which table collections errors are stored.

1 Answers  

---