Data Mining and Data Warehouse Solved MCQs

1.

__________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

A. data mining.
B. data warehousing.
C. web mining.
D. text mining.
Answer» B. data warehousing.
2.

The data Warehouse is__________.

A. read only.
B. write only.
C. read write only.
D. none.
Answer» A. read only.
3.

Expansion for DSS in DW is__________.

A. decision support system.
B. decision single system.
C. data storable system.
D. data support system.
Answer» A. decision support system.
4.

The important aspect of the data warehouse environment is that data found within the data warehouse is___________.

A. subject-oriented.
B. time-variant.
C. integrated.
D. all of the above.
Answer» D. all of the above.
5.

The time horizon in Data warehouse is usually __________.

A. 1-2 years.
B. 3-4years.
C. 5-6 years.
D. 5-10 years.
Answer» D. 5-10 years.
6.

The data is stored, retrieved & updated in ____________.

A. olap.
B. oltp.
C. smtp.
D. ftp.
Answer» B. oltp.
7.

__________describes the data contained in the data warehouse.

A. relational data.
B. operational data.
C. metadata.
D. informational data.
Answer» C. metadata.
8.

____________predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions.

A. data warehouse.
B. data mining.
C. datamarts.
D. metadata.
Answer» B. data mining.
9.

__________ is the heart of the warehouse.

A. data mining database servers.
B. data warehouse database servers.
C. data mart database servers.
D. relational data base servers.
Answer» B. data warehouse database servers.
10.

________________ is the specialized data warehouse database.

A. oracle.
B. dbz.
C. informix.
D. redbrick.
Answer» D. redbrick.
11.

________________defines the structure of the data held in operational databases and used by operational applications.

A. user-level metadata.
B. data warehouse metadata.
C. operational metadata.
D. data mining metadata.
Answer» C. operational metadata.
12.

________________ is held in the catalog of the warehouse database system.

A. application level metadata.
B. algorithmic level metadata.
C. departmental level metadata.
D. core warehouse metadata.
Answer» B. algorithmic level metadata.
13.

_________maps the core warehouse metadata to business concepts, familiar and useful to end users.

A. application level metadata.
B. user level metadata.
C. enduser level metadata.
D. core level metadata.
Answer» A. application level metadata.
14.

______consists of formal definitions, such as a COBOL layout or a database schema.

A. classical metadata.
B. transformation metadata.
C. historical metadata.
D. structural metadata.
Answer» A. classical metadata.
15.

_____________consists of information in the enterprise that is not in classical form.

A. mushy metadata.
B. differential metadata.
C. data warehouse.
D. data mining.
Answer» A. mushy metadata.
16.

. ______________databases are owned by particular departments or business groups.

A. informational.
B. operational.
C. both informational and operational.
D. flat.
Answer» B. operational.
17.

The star schema is composed of __________ fact table.

A. one.
B. two.
C. three.
D. four.
Answer» A. one.
18.

The time horizon in operational environment is ___________.

A. 30-60 days.
B. 60-90 days.
C. 90-120 days.
D. 120-150 days.
Answer» B. 60-90 days.
19.

The key used in operational environment may not have an element of__________.

A. time.
B. cost.
C. frequency.
D. quality.
Answer» A. time.
20.

Data can be updated in _____environment.

A. data warehouse.
B. data mining.
C. operational.
D. informational.
Answer» C. operational.
21.

Record cannot be updated in _____________.

A. oltp
B. files
C. rdbms
D. data warehouse
Answer» D. data warehouse
22.

The source of all data warehouse data is the____________.

A. operational environment.
B. informal environment.
C. formal environment.
D. technology environment.
Answer» A. operational environment.
23.

Data warehouse contains_____________data that is never found in the operational environment.

A. normalized.
B. informational.
C. summary.
D. denormalized.
Answer» C. summary.
24.

The modern CASE tools belong to _______ category.

A. analysis.
B. development
C. coding
D. delivery
Answer» A. analysis.
25.

Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process.

A. 10 percent.
B. 20 percent.
C. 40 percent
D. 80 percent.
Answer» D. 80 percent.
Tags
Question and answers in Data Mining and Data Warehouse, Data Mining and Data Warehouse multiple choice questions and answers, Data Mining and Data Warehouse Important MCQs, Solved MCQs for Data Mining and Data Warehouse, Data Mining and Data Warehouse MCQs with answers PDF download

We need your help!

We're developing a website for study materials for students.
We would love to hear your answers to some of the questions.

Take Survey