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]
