Papers / AKTU / MCA / Data Mining
AKTU · MCA · 3rd semester

AKTU MCA Data Warehousing & Data Mining (KCA012) Question Paper 2022-23

UniversityDr. A.P.J. Abdul Kalam Technical University (AKTU), Lucknow
CourseMCA, Semester III
SubjectData Warehousing & Data Mining (KCA012)
ExamTheory Examination 2022-23 (odd semester)
Time · Marks3 hours · 100 marks
SourceAKTU question paper, from the ABESIT question paper bank
View original PDF Other years

Note: Attempt all Sections. If require any missing data; then choose suitably.

Section A

Q1. Attempt all questions in brief · 2 × 10 = 20 marks

  1. Write down the components of data warehouse.
  2. What is meta data?
  3. What is SMP?
  4. What do you mean by workload matrix?
  5. What are the steps involved in data transformation?
  6. What is binning technique?
  7. Briefly describe genetic algorithm.
  8. Explain market basket analysis.
  9. What is MOLAP?
  10. Define web mining.

Section B

Q2. Attempt any three of the following · 10 × 3 = 30 marks

  1. Define data warehouse. What are the key features of data warehouse?
  2. What is data warehouse planning? Explain its activities.
  3. Describe the steps involved in data mining when viewed as a process of knowledge discovery.
  4. Describe classification. Also discuss Naive Bayesian classification.
  5. Describe various OLAP operations in multidimensional data model.

Section C

Q3

Attempt any one part of the following · 10 × 1 = 10 marks

  1. Write short note on : (i) Shared-disk architecture (ii) Distributed memory architecture
  2. Differentiate between OLAP and OLTP.

Q4

Attempt any one part of the following · 10 × 1 = 10 marks

  1. Discuss master slave processing with the help of diagram.
  2. Explain two primary categories of parallel hardware used for data warehousing.

Q5

Attempt any one part of the following · 10 × 1 = 10 marks

  1. What do you mean by cleaning of the data? Explain the important types of data cleaning.
  2. What is decision tree? Explain the classification by decision tree induction.

Q6

Attempt any one part of the following · 10 × 1 = 10 marks

  1. What is clustering? Briefly explain k-means clustering algorithm.
  2. Describe neural network. How the neural network is useful in classification.

Q7

Attempt any one part of the following · 10 × 1 = 10 marks

  1. Write a short note on the following: (i) Tuning the data warehouse (ii) Testing the data warehouse
  2. List various algorithms used in web mining. Briefly discuss any one of them.

Short on time? See the most repeated AKTU Data Warehousing and Data Mining questions across all years.

Other years

More AKTU Data Mining papers on LearnAIFast.

MCA Data Warehousing & Data Mining 2025-26 (BMC012) MCA Data Warehousing & Data Mining 2024-25 (KCA012) MCA Data Warehousing & Data Mining 2023-24 (KCA012) MCA Data Warehousing & Data Mining 2021-22 (KCA012) Data Warehousing & Data Mining 2025-26 (BOE095) Data Warehousing & Data Mining 2024-25 (KOE093) Data Warehousing & Data Mining 2023-24 (KOE093) Data Warehousing and Data Mining 2023-24 (KAI075) Data Warehousing & Data Mining 2022-23 (KOE093) Data Warehousing & Data Mining 2021-22 (KOE093) Data Warehousing and Data Mining 2018-19 (RIT062) Data Warehousing & Data Mining 2016-17 (NCS066) All AI & ML papers

This paper is reproduced for study purposes only. Copyright belongs to AKTU. Source: the question paper bank of ABES Institute of Technology, an AKTU-affiliated college. If you own the copyright and want it removed, email learnwithskillnest@gmail.com and we will take it down.