MCASemester 32022-23Data Warehousing Data MiningKCA-012
View PDFDownload

Data Warehousing Data Mining (KCA-012) - AKTU Question Paper 2022-23

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 2022-23. 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:2022-23
University:AKTU / UPTU

Rate this paper

Questions Asked in 2022-23

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

Section AAttempt all questions in brief. 2 x 10 = 20
  • a
    Write down the components of data warehouse
  • d
    What do you mean by workload matrix?
  • e
    What are the steps involved in data transformation?
  • f
    What is binning technique?
  • g
    Briefly describe genetic algorithm
  • h
    Explain market basket analysis. i. What is MOLAP? j. Define web mining
Section BAttempt any three of the following: 10 x 3 = 30
  • a
    Define data warehouse. What are the key features of data war ehouse?
  • b
    What is data warehouse plan ning? Explain its activities
  • c
    Describe the steps involved i n data mining when viewed as a process of knowled ge discovery
  • d
    Describe classification. Also discuss Naive Bayesian classif ication
  • e
    Describe various OLAP opera tions in multidimensional data model
Section CAttempt any one part of the following: 10 x 1 = 10
  • a
    Write short note on : (i) Shared-disk architecture (ii) Distributed memory architecture
  • b
    Differentiate bet ween OLAP and OLTP
  • a
    Discuss master slave proces sing with the help of diagram
  • b
    Explain two primary categorie s of parallel hardware used for data warehousing
  • a
    What do you mean by cleaning of the data? Explain the import ant types of data cleaning
  • b
    What is decision tree? Explai n the classification by decision tree induction
  • a
    What is clustering? Briefly e xplain k-means clustering algorithm
  • b
    Describe neural network. How the neural network is useful in classification
  • a
    Write a short note on the following: (i) Tuning the data warehouse (ii) Testing the data warehouse
  • b
    List various algorith ms used in web mining. Briefly discuss any one of them

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

Write down the components of data warehouse

Appeared in: 2021-22 · 2022-23

2x

What do you mean by workload matrix?

Appeared in: 2021-22 · 2022-23

2x

Describe the steps involved i n data mining when viewed as a process of knowled ge discovery

Appeared in: 2021-22 · 2022-23

2x

Describe classification. Also discuss Naive Bayesian classif ication

Appeared in: 2021-22 · 2022-23

2x

Differentiate bet ween OLAP and OLTP

Appeared in: 2022-23 · 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 Mining2023-24

More MCA Semester 3 (2022-23) Papers

Other subjects from same semester and session

Computer Networks2022-23Compiler Design2022-23Big Data2022-23Software Testing Quality Assurance2022-23Software Project Management2022-23Simulation Modeling2022-23Cryptography And Network Security2022-23Software Engineering2022-23
View all MCA Semester 3 2022-23 papers →