Q1. Describe the term ‘Living Sample Database’ in detail with proper example.
Q2. What do you mean by Partitioning of data? Describe with an illustration. Describe the ways to carry it out. Which is better and explain why?
Q3. Describe how process and data model can apply to the architecture environment? Explain why Process model is not appropriate for the data warehouse.
Q4. Describe in detail all the three data warehouse data models.
Q5. Describe star join with an illustration. Making a star join for the data warehouse is a mistake. Comment on it.
Q6. Describe Multidimensional DBMS. Describe the ways of implementing it by providing its weaknesses and strength. Explain how is Multidimensional DBMS differing from the warehouse?