CS614 Final Term Current Paper (Feb 2011)

CS614 Final Term Current Paper (Feb 2011)

Q1: write a querry to extract total number of female students registered in BS Telecom. 5 marks 

Q2: describe the lessons learn at during agri-data ware house case study. 5 marks 

Q3: what are the fundamental strengths and weakness of k means clustering? 5 marks 

Q4: data profiling is a process of gathering information about columns, what are the purpose that it must fulfill? describe briefly.3 marks

Q5: define additive and non additive facts. 

Q6: What are three fundamental reasons for warehousing web data? 3 marks 

Q7: what are the two basic data warehousing implementation strategies and their suitability conditions.? 3marks 

Q8: list and explain fundamental advantages of bit map indexing. 3 marks 

Q9: what are major operations of data mining. [2]

Q10: what will be the effect if we program a package by using DTS object modal? 2

Q11: write down the steps of handling skew in range partitioning.

Q12: what type of anomalies exist if a table is in 2NF no tin 3NF? [2]

Q13: what are three methods for creating a DTS package? [2]

Q14: whtat are the two extremes for technical architecture design? which one is better? [2]