DBMS-Data Warehousing and Data Mining Questions and Answers
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
DBMS-Data Warehousing and Data Mining
Showing 10 of
36 questions
21. Which of the following is an advantage of data warehousing ?
- Better enterprise intelligence.
- Business recengineering.
- Cost-Effective decision-making.
- All of these.
23. 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 ?
- Data modelling
- Databases
- Application development methods,
- All of these
24. Data acquisition component of data warehouse is responsible for
- collection of data from legacy systems.
- convert legacy data into usable form for the users.
- importing and exporting data from legacy system.
- All of these.
25. Data access component of data warehouse is responsible for
- providing the end-users with access to the stored warehouse information through the use of specialised end-user tools.
- Collecting the data from legacy system and convert them into usable form for the users.
- holding a vast amount of information froma wide variety of sources.
- None of these
26. Data acquisition component of data warehouse is responsible for
- Providing the end-users with access tot he stored warehouse information through the use of specidalised end-user tools.
- collecting the data from legacy system and convert them into usable form for the users.
- holding a vast amount of information from a wide variety of sources.
- None of these
27. Data Storage component of data warehouse is responsible for
- providing the end-users with access to the stored warehouse information through the use of specidalised end-user tools.
- collecting the data from legacy system and convert them into usable form for the users.
- holding a vast amount of information from a wide variety of sources.
- None of these.
28. The data warehouse structure is based on
- a relational database management system sever that functions as the central repository for informational data.
- a network database system
- Both (a) and (b)
- None of these
29. In the data warehouse structure.
- operational data processing is completely separate from data warehouse processing.
- opeational data and processing is part of data warehouse processing.
- Both (a) and (b)
- None of these