Data Mining and Business Intelligence 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. integrate
D. D All of the above
Answer» D. 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. Data marts
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. 30 percent
D. 40 percent
Answer» D. 40 percent
Tags
Question and answers in Data Mining and Business Intelligence, Data Mining and Business Intelligence multiple choice questions and answers, Data Mining and Business Intelligence Important MCQs, Solved MCQs for Data Mining and Business Intelligence, Data Mining and Business Intelligence 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