MCASemester 32023-24Data Warehousing Data MiningKCA-012
View PDFDownload

Data Warehousing Data Mining (KCA-012) - AKTU Question Paper 2023-24

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 2023-24. 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:2023-24
University:AKTU / UPTU

Rate this paper

Questions Asked in 2023-24

Data Warehousing Data Mining (KCA-012) — complete question paper · 100 marks · 3 Hours

Section AAttempt all q u e s t i o n s i n b r i e f . 2*10 = 20
  • a
    How Data Warehouse is di fferent from Database? 2 1
  • b
    How Data Mining is different from Data Warehousing? 2 1
  • c
    Why is Data Transformation required? 2 2
  • d
    Discuss how regression is related to classification 2 3
  • e
    What do mean by support and confidence in association rule mining? 2 3
  • f
    Define Slice and Dice operation. 2 3
  • g
    What is data generalization? 2 4
  • h
    What is data Aggregation? 2 5 i. What do you mean by temporal mining? 2 5 j. Explain the concept of concept hierarchies in data mining. 2 2
Section BAttempt any three o f t h e f o l l o w i n g : 10*3 = 30
  • a
    Write detail about the 3-tie r architecture a nd the implement ation of data warehouse with a neat diagram. 10 1
  • b
    Differentiate between the thr ee main types of data usage: Information Processing, Analytical Processing and Data Mining. Examine the motivation behind OLAP minin
  • c
    Find all frequent item sets for the given training set using Aprori Algorithm. TID ITEMS BOUGHT
  • d
    Examine how classification tasks performed by SVM. 10 4 .e. Describe various OLA P operations with 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 : 10*1 = 10
  • a
    Briefly discuss the three schemas for multidimensional datab ases that consists of 4 dimensions (Time, Branch, Item, Location). Include the appropriate measures required for the schemas
  • b
    Discuss why do we need to pre- process the data. Mention the various tasks to be accomplished as part of pre-processing. Elaborate each. 10 2
  • a
    Draw the Data Warehouse architecture and discuss its various components. 10 1
  • b
    Discuss the various appli cations of Data Warehousing? 10 1
  • a
    How classification is different from clustering? Discuss Dec ision Tree based classification technique in detail. 10 3
  • b
    What do you mean by Data Extr action? Discuss the tools used for Data Extraction. 10 3
  • a
    How Bayes Theorem can be use d for classification task? Explain 10 4
  • b
    Write short notes on i) CURE ii) DNSCAN
  • a
    Discuss in detail the secur ity issues in Data Warehousing. 10 5
  • b
    Write Notes on i) Web Mining ii) Spatial Mining

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

How Data Mining is different from Data Warehousing? 2 1

Appeared in: 2023-24 · 2024-25

2x

What is data generalization? 2 4

Appeared in: 2021-22 · 2023-24

2x

Write short notes on i) CURE ii) DNSCAN

Appeared in: 2021-22 · 2023-24

2x

Discuss in detail the secur ity issues in Data Warehousing. 10 5

Appeared in: 2023-24 · 2024-25

Data Warehousing Data Mining — Other Year Papers

AKTU Data Warehousing Data Mining PYQs from other sessions

Data Warehousing Data Mining2021-22Data Warehousing Data Mining2022-23Data Warehousing Data Mining2023-24Data Warehousing Data Mining2024-25Data Warehousing Data Mining2021-22Data Warehousing Data Mining2022-23

More MCA Semester 3 (2023-24) Papers

Other subjects from same semester and session

Software Testing Quality Assurance2023-24Cryptography Network Security2023-24Simulation Modeling2023-24Web Technology2023-24Computer Network2023-24Digital Image Processing2023-24Big Data2023-24Cloud Computing2023-24
View all MCA Semester 3 2023-24 papers →