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) — extracted question text · 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. Check the original PDF for equations, diagrams and complete wording. Extracted: 2026-08-23.

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 →

Syllabus & More PYQs

Paper solve karne se pehle unit-wise syllabus dekh lo

AKTU 2nd Year MCA PYQs