Pixwords 2 lettres Pixwords 6 lettres Pixwords 9 lettres Pixwords 14 lettres Pixwords 15 lettres pixwordssolution.com
Sample Paper for Integrated MCA in Data Mining & Warehousing 4th yearItsMyAcademy.com

Sample Paper for Integrated MCA in Data Mining & Warehousing 4th year



Time -3 hours                                                                                                Max Marks: 100 

 Note:  1. Attempt any five questions.

     2. All question carry equal marks.

Q1. (a)  What do you understand by data warehouse? What are the characteristics of Data


(b)  List some advantages of data warehouse?


Q2.      Explain structure of the data warehouse? Discuss in detail all the steps involved in making a data warehouse?


Q3. (a)  Explain OLTP and OLAP and also discuss differences between them?

(b)  It is always said that the data warehouse should be built separate. Justify?


Q4. (a)  Draw and explain any two models of data warehouse?

(b)  Draw and explain 4-dimensional data cube with an example?


Q5.      Explain the following terms;

i.            Project Estimation
ii.            Analyzing Probability and Risk

iii.            Managing Risk

iv.            Return on Investment


Q6. (a)            What is Data mining (DM)? Define and describe relationship and patterns detected in data mining. What is the scope of data mining?

(b) Explain cluster analysis?


Q7.    Explain the following stages used in data preprocessing for data mining;

  •                                 i.            Data selection
  •                               ii.            Data cleaning
  •                             iii.            Date reduction
  •                             iv.            Data enrichment
  •                               v.            Pattern evaluation


Q8.     Explain MOLAP and ROLAP? Explain the following OLAP operations in the multidimensional data model with the diagram and an example                               (20)

  •                                 i.            Dice for
  •                               ii.            Slice for
  •                             iii.            Drill down
  •                             iv.            Roll up
  •                               v.            Pivot


Q9. (a) Is it necessary that every small or big company should have a data warehouse? Justify your answer?

(b) Explain the three-tier data warehouse architecture?                                     (14)


Note: Above Sample Paper for Integrated MCA in Data Mining & Warehousing 4th year has been prepared after reviewing few universities sample papers. We are not sure whether same or similar question papers pattern does your university has or not. We are just trying to help you by providing the possibilities. We always suggest you to go thoroughly with textbooks, teacher’s notes and the syllabus for better preparation of your coming examination.

All the Best!!