## Solution of Assignment Synopsis & Project Dissertation Report

Without time Running Time running is not applicable for old student.

 Title Name Amity Solved Assignment MCA for Data warehousing and Mining semester 6 University AMITY Service Type Assignment Course B.Sc-(IT) Semester Semester-VI Course: B.Sc-(IT) Short Name or Subject Code Data warehousing and Mining Commerce line item Type Semester-VI Course: B.Sc-(IT) Product Assignment of B.Sc-(IT) Semester-VI (AMITY) Price PRICE INR Click to View Price

## Questions:-

Data warehousing and Mining

Assignment A

1. What are the steps involved in data mining process?

Ans.

1. What is the difference between OLTP and data warehouse?

Ans.

1. What is spatial mining?

Ans.

1. Why pre-process the data?

Ans.

1. Define gain ratio.

Ans.

1. Compare clustering and classification.

Ans.

1. List any four data mining applications.

Ans.

1. What are the goals of time series analysis?

Ans.

Assignment B

Case Detail:

Suppose that the data for analysis includes the attribute age. The age values for the data tuples are (in increasing order)

13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25, 25, 25, 25, 30, 33, 33, 35, 35, 35, 35, 36, 40, 45, 46, 52, 70.

1. What is the mean of the data? What is the median?

Ans.

1. What is the mode of the data? Comment on the data’s modality (i.e., bimodal, trimodal, etc.).

Ans:

1. What is the midrange of the data?

Ans.

Assignment C

Question No.  1    Marks - 10

Data mining can also applied to other forms such as................

1. I) Data streams
1. ii) Sequence data

iii) Networked data

1. iv) Text data
1. v) Spatial data

Options

1. I , ii, iii and v only
1. ii, iii, iv and v only
2. I , iii, iv and v only
1. All I , ii, iii, iv and v

Question No.  2    Marks - 10

Which of the following is not a data mining functionality?

Options

1. Characterization and Discrimination
1. Classification and regression
1. Selection and interpretation
1. Clustering and Analysis

Question No.  3    Marks - 10

............................. is a summarization of the general characteristics or features of a target class of data.

Options

1. Data Characterization
1. Data Classification
1. Data discrimination
1. Data selection

Question No.  4    Marks - 10

............................. is a comparison of the general features of the target class data objects against the general features of objects from one or multiple contrasting classes.

Options

1. Data Characterization
1. Data Classification
1. Data discrimination
1. Data selection

Question No.  5    Marks - 10

Strategic value of data mining is......................

Options

1. cost-sensitive
1. work-sensitive
1. time-sensitive
1. technical-sensitive

Question No.  6    Marks - 10

............................. is the process of finding a model that describes and distinguishes data classes or concepts.

Options

1. Data Characterization
1. Data Classification
1. Data discrimination
1. Data selection

Question No.  7    Marks - 10

The various aspects of data mining methodologies is/are...................

1. i) Mining various and new kinds of knowledge
1. ii) Mining knowledge in multidimensional space

iii) Pattern evaluation and pattern or constraint-guided mining.

1. iv) Handling uncertainty, noise, or incompleteness of data

Options

1. i, ii and iv only
1. ii, iii and iv only
1. i, ii and iii only
1. All i, ii, iii and iv

Question No.  8    Marks - 10

. The full form of KDD is

Options

1. Knowledge Database
1. Knowledge Discovery Database
1. Knowledge Data House
1. Knowledge Data Definition

Question No.  9    Marks - 10

The output of KDD is

Options

1. Data
1. Information
1. Query
1. Useful information

Question No.  10  Marks - 10

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

Options

1. Data Mining.
1. Data Warehousing.
1. Web Mining.
1. Text Mining.

Question No.  11  Marks - 10

The data Warehouse is__________.

Options

1. Write only.
1.

Question No.  12  Marks - 10

Expansion for DSS in DW is:

Options

1. Decision Support system.
1. Decision Single System.
1. Data Storable System.
1. Data Support System

Question No.  13  Marks - 10

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

Options

1. Subject-oriented.
1. Time-variant.
1.
1. All of the above.

Question No.  14  Marks - 10

The time horizon in Data warehouse is usually __________.

Options

1. 1-2 years.
1. 3-4years.
1. 5-6 years.
1. 5-10 years.

Question No.  15  Marks - 10

The data is stored, retrieved & updated in ____________.

Options

1.
1.
1.
1.

Question No.  16  Marks - 10

.__________describes the data contained in the data warehouse.

Options

1. Relational data.
2. Operational data.
4. Informational data.

Question No.  17  Marks - 10

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

Options

1. Data warehouse.
1. Data mining.
1.
1.

Question No.  18  Marks - 10

__________ is the heart of the warehouse.

Options

1. Data mining database servers.
1. Data warehouse database servers.
1. Data mart database servers.
1. Relational data base servers

Question No.  19  Marks - 10

. ________________ is the specialized data warehouse database.

Options

1.
1.
1.
1.

Question No.  20  Marks - 10

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

Options

Question No.  21  Marks - 10

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

Options

Question No.  22  Marks - 10

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

Options

Question No.  23  Marks - 10

What consists of formal definitions, such as a COBOL layout or a database schema?

Options

Question No.  24  Marks - 10

__ consists of information in the enterprise that is not in classical form.

Options

1. Data warehouse.
1. Data mining.

Question No.  25  Marks - 10

. ______________databases are owned by particular departments or business groups.

Options

1.
1.
1. Both informational and operational.
1.

Question No.  26  Marks - 10

. The star schema is composed of __________ fact table.

Options

1. one
2. two
3. three
4. four

Question No.  27  Marks - 10

The time horizon in operational environment is ___________.

Options

1. 30-60 days.
1. 60-90 days.
1. 90-120 days.
1. 120-150 days.

Question No.  28  Marks - 10

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

Options

1.
1.
1.
1.

Question No.  29  Marks - 10

Data can be updated in _____environment.

Options

1. Data warehouse.
1. Data mining.
1.
1. Informational

Question No.  30  Marks - 10

Record cannot be updated in _____________.

Options

1. OLTP
1. files
1. RDBMS
1. data warehouse

Question No.  31  Marks - 10

The source of all data warehouse data is the____________.

Options

1. Operational environment.
1. Informal environment.
1. Formal environment.
1. Technology environment.

Question No.  32  Marks - 10

Data warehouse contains _____________ data that is never found in the operational environment.

Options

1.
1.
1.
1.

Question No.  33  Marks - 10

The modern CASE tools belong to _______ category.

Options

1.
1. Development
1. Coding
1. Delivery

Question No.  34  Marks - 10

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

Options

1. 10 percent.
1. 20 percent.
1. 40 percent
1. 80 percent.

Question No.  35  Marks - 10

Detail data in single fact table is otherwise known as__________.

Options

1. Mono atomic data.
1. Diatomic data.
1. Atomic data.
1. Multi atomic data.

Question No.  36  Marks - 10

_______test is used in an online transactional processing environment.

Options

1.
1.
1.
1.

Question No.  37  Marks - 10

___________ is a good alternative to the star schema.

Options

1. Star schema.
1. Snowflake schema.
1. Fact constellation.
1. Star-snowflake schema.

Question No.  38  Marks - 10

The biggest drawback of the level indicator in the classic star-schema is that it limits_________.

Options

1.
1.
1.
1.

Question No.  39  Marks - 10

A data warehouse is _____________.

Options

1. Updated by end users.
1. contains numerous naming conventions and formats
1. Organized around important subject areas.
1. Contains only current data.

Question No.  40  Marks - 10

An operational system is _____________.

Options

1. Used to run the business in real time and is based on historical data.
2. Used to run the business in real time and is based on current data.
3. Used to support decision making and is based on current data.
4. Used to support decision making and is based on historical data.

## 4.8 / 5

#### Rating breakdown

5
80% Complete (danger)
1
4
80% Complete (danger)
1
3
80% Complete (danger)
0
2
80% Complete (danger)
0
1
80% Complete (danger)
0

January 29, 2015