BCA Semester 6 - Data Ware Housing and Data Mining - Q Paper (2015)

END TERM EXAMINATION

SIXTH SEMESTER [BCA] MAY-JUNE - 2015

Time: 3 Hours		Maximum Marks: 75
	Paper Code: BCA302     Subject: DATA WAREHOUSE AND DATA MINING
	Attempt Any five questions including Q No. 1 which is compulsory. Select one question from each unit. Calculator is not allowed.
Q1:	Answer the following questions: (a) What is a data warehousing and why it is important for decision support? (b) What is data preprocessing? Discuss. (c) Explain different OLAP operations. (d) What do you understand by frequent patterns? Explain. (e) Datamining is multidisciplinary field. Explain this statement. (f) Differentiate between Classification and Clustering. (g) What are the applications of data mnining? Discuss (h) Define support and confidence. (i) Can a data mining system generate interesting patterns? Justify (j) What is knowledge discovery in Database? Explain	(10 × 2.5 = 25)
Q2:	(a) Discuss Data integration and Data transformation in detail. (b) Explain the architecture of Data mining system with suitable diagram.	(6) (6.5)
Q3:	Differentiate between the following: (a) OLAP and OLAM (b) Data mining and KDD (c) Classification and Prediction.	(4) (4) (4.5)
Q4:	(a) What is back propagation? How is back propogation performed? (b) Explain decision tree in classification.	(6) (6.5)
Q5:	(a) What are the major issues in data mining? Discuss. (b) Discuss the social impact of Data mining in detail.	(6) (6.5)
Q6:	(a) How would you measure the quality of Cluster? Explain. (b) List the different categorization of OLAP tools.	(6) (6.5)
Q7:	Explain the design and construction of Data warehouse in detail.	(12.5)
Q8:	Write note on any two of the following: (a) Temporal Database vs Sequential Database (b) Classification vs Prediction (c) Lazy Learners	(6.25x 2 = 12.5)