MCASemester 32021-22Data Warehousing Data MiningKCA-012

Data Warehousing Data Mining (KCA-012) - AKTU Question Paper 2021-22

MCA · Semester 3 · Free PDF Download

This is the official AKTU Data Warehousing Data Mining Previous Year Question Paper for MCA Semester 3, academic session 2021-22. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:MCA
Semester:Semester 3
Session:2021-22
University:AKTU / UPTU

Rate this paper

Questions Asked in 2021-22

Data Warehousing Data Mining (KCA-012) — complete question paper

Section AAttempt all q u e s t i o n s i n b r i e f . 2 x 10 = 20
  • a
    List down the Key Features of Data Warehouse. 2 1
  • b
    Define Data Mart. 2 1
  • d
    What is Master-slav e processing? 2 2
  • e
    Briefly explain Association rules. 2 3
  • f
    Define Data cleaning. 2 3
  • g
    What is data Generalization? 2 4
  • h
    List down the various measures of Central Tendency. 2 4 i. What are the characteristics of OLAP? 2 5 j. Define Web Mining. 2 5
Section BAttempt any three o f t h e f o l l o w i n g :
  • a
    What do you mean by Data Warehouse? Discuss the key features with suitable examples
  • b
    What is data Warehouse implementation? What are the key considerations that are taken while finalizing the physical war ehouse schema design?
  • c
    Describe the steps involved in data mining when viewed as a process of knowledge discovery
  • d
    Describe Classification. Briefly Outline the major ideas of Bayesian Classification
  • e
    Describe various OLAP ope rations with an example. 10 5
Section CAttempt any one p a r t o f t h e f o l l o w i n g :
  • a
    Write a note on Shared disk a nd Shared nothing architecture. 10 1
  • b
    What is multidimensional data model? How do we convert table s & spreads sheets to data cubes
  • a
    What do you mean by Workload matrix? 10 2
  • b
    Explain Attribute Relevance Analysis with an example. 10 2
  • a
    Describe the basic architecture of data mining. 10 3
  • b
    Why data preprocessing is requi red in Data Mining. Explain. 10 3
  • a
    What is clustering? List types of clustering. Explain any on e approach for clustering
  • b
    Describe CLIQUE algorithm. 10 4
  • a
    Write short-notes on: (i) Crawlers (ii) Harvest System
  • b
    Explain & Define Markov Model. 10 5

Question text is extracted from the official AKTU question paper PDF above. Hindi translations are omitted — every question is printed in English in the original paper. Last verified: 2026-08-23.

Repeated Questions — KCA-012

Questions that appeared in more than one session, found by comparing 4 years of Data Warehousing Data Mining papers (2021-22, 2022-23, 2023-24, 2024-25)

2x

List down the Key Features of Data Warehouse. 2 1

Appeared in: 2021-22 · 2022-23

2x

What is data Generalization? 2 4

Appeared in: 2021-22 · 2023-24

2x

Describe the steps involved in data mining when viewed as a process of knowledge discovery

Appeared in: 2021-22 · 2022-23

2x

Describe various OLAP ope rations with an example. 10 5

Appeared in: 2021-22 · 2024-25

2x

What do you mean by Workload matrix? 10 2

Appeared in: 2021-22 · 2022-23

2x

Write short-notes on: (i) Crawlers (ii) Harvest System

Appeared in: 2021-22 · 2023-24