CS614 VU Final Term Current Paper 

Fall 2012 – 23 February 2013

CS614 VU Final Term Current Paper Fall 2012 – 23 February 2013

1. Horizontal splitting of tables

2. Nested loop join and its variants

3. Hash based join and its working

4. Define DWH, data mining & knowledge discovery in database

5. Kimball’s life cycle model

6. Why should companies entertain students to visit their company’s place?

7. Static & dynamic attributes and examples from agriDWH

8. Write SQL to fetch total number of female students registered in BS telcom (5 marks)

9. Is it possible to have erroneous data in DWH? How this will impact business processes? (5 marks)

10. How is hardware utilization different in DWH? (2 marks)

11. In case of non uniform distribution, what will be the impact on performance? (5 marks)

12. Why pilot project methodology is highly recommended in DWH?