Pixwords 2 lettres Pixwords 7 lettres Pixwords 9 lettres Pixwords 13 lettres Pixwords 17 lettres pixword Français solution
Sample Paper for MCA of Data Mining & Data WarehousingItsMyAcademy.com

Sample Paper for MCA of Data Mining & Data Warehousing


Sample Paper for MCA of Data Mining & Data Warehousing

TERM END EXAMINATIONS, AUGUST/SEPTEMBER -2011

MASTER OF COMPUTER APPLICATION, SEMESTER-V, YEAR-3

       DATA MINING AND DATA WAREHOUSING

Duration -3 Hrs                                                                                                                                                        Max Marks: 60

Note:  1. Attempt any five questions.

     2. All question carry equal marks.

Q1. What is Data mining (DM)? Define and describe relationship and patterns detected in data

Mining. What is the scope of data mining?

 

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;

  1.                                 i.            Project Estimation
  2.                               ii.            Analyzing Probability and Risk
  3.                             iii.            Managing Risk
  4.                             iv.            Return on Investment

 

Q6.  (a) Discuss various problems with Data Warehousing.
(b) Explain cluster analysis?

 

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

  1.                                 i.            Data selection
  2.                               ii.            Data cleaning
  3.                             iii.            Date reduction
  4.                             iv.            Data enrichment
  5.                               v.            Pattern evaluation

 

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

  1.                                 i.            Dice for
  2.                               ii.            Slice for
  3.                             iii.            Drill down
  4.                             iv.            Roll up
  5.                               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?

Comments