Data Warehousing and Data Mining Questions with Answers | Page 3

Data Warehousing and Data Mining questions with answers are crucial for understanding how organizations manage and analyze large datasets. These DBMS programming questions and answers explore concepts like ETL processes, OLAP operations, clustering, classification, and association rule mining. Practicing these questions helps students gain clarity on real-world data analytics and storage architecture, often tested in company placement papers and technical interviews. If you’re preparing for TCS, Capgemini, or Wipro, reviewing these DBMS-based data mining questions will strengthen your database and analytics knowledge for exams and interviews

Showing 10 of 36 questions

Per page:

Q21

Which of the following is an advantage of data warehousing ?

A Better enterprise intelligence.
B Business recengineering.
C Cost-Effective decision-making.
D All of these.

Answer: Option D

Q22

Data warehousing concept started in the

A 1970s
B 1980s
C 1990s
D early 2000

Answer: Option B

Q23

Which of the following technological advances in data modelling, databases and application development methods resulted into paradigm shift from informaion system (IS) approach to business-driven warehouse implementations ?

A Data modelling
B Databases
C Application development methods,
D All of these

Answer: Option D

Q24

Data acquisition component of data warehouse is responsible for

A collection of data from legacy systems.
B convert legacy data into usable form for the users.
C importing and exporting data from legacy system.
D All of these.

Answer: Option D

Q25

Data access component of data warehouse is responsible for

A providing the end-users with access to the stored warehouse information through the use of specialised end-user tools.
B Collecting the data from legacy system and convert them into usable form for the users.
C holding a vast amount of information froma wide variety of sources.
D None of these

Answer: Option A

Q26

Data acquisition component of data warehouse is responsible for

A Providing the end-users with access tot he stored warehouse information through the use of specidalised end-user tools.
B collecting the data from legacy system and convert them into usable form for the users.
C holding a vast amount of information from a wide variety of sources.
D None of these

Answer: Option B

Q27

Data Storage component of data warehouse is responsible for

A providing the end-users with access to the stored warehouse information through the use of specidalised end-user tools.
B collecting the data from legacy system and convert them into usable form for the users.
C holding a vast amount of information from a wide variety of sources.
D None of these.

Answer: Option C

Q28

The data warehouse structure is based on

A a relational database management system sever that functions as the central repository for informational data.
B a network database system
C Both (a) and (b)
D None of these

Answer: Option A

Q29

In the data warehouse structure.

A operational data processing is completely separate from data warehouse processing.
B opeational data and processing is part of data warehouse processing.
C Both (a) and (b)
D None of these

Answer: Option A

Q30

Data in ODS is

A Subject-oriented.
B integrated.
C volatile.
D All of these

Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search

Back to Database

DBMS-Data Warehousing and Data Mining Questions and Answers

📚 More from Database

Database

Other Subjects

DBMS-Data Warehousing and Data Mining Questions and Answers

📚 More from Database

Database

Other Subjects

Report a Problem