image

Solution of Assignment Synopsis & Project Dissertation Report


Note: ⇩    Fill the Name, Email and Mobile to get unlock the priclist...!!!!



Online-Typing-and-Filling

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)
Session
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
Download Question File
Download Answer File 955682842317.docx (Purchase the product for download...!!!)

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. Read only.
  1. Write only.
  1. Read 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.
  3. Metadata.      
  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       

  1. User-level metadata.
  1. Data warehouse metadata.
  1. Operational metadata.
  1. Data mining metadata.

Question No.  21  Marks - 10

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

Options       

  1. Application level metadata.
  1. Algorithmic level metadata.
  1. Departmental level metadata.
  1. Core warehouse metadata.

Question No.  22  Marks - 10

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

         

Options       

  1. Application level metadata.
  1. User level metadata.
  1. Enduser level metadata.
  1. Core level metadata.

Question No.  23  Marks - 10

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

Options       

  1. Classical metadata.
  1. Transformation metadata.
  1. Historical metadata.
  1. Structural metadata.

Question No.  24  Marks - 10

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

         

Options       

  1. Mushy metadata.
  1. Differential metadata.
  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.


Questions:-



Only after making the payment you would be able to see the answer...!!!

Review

Average user rating

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
This was nice in buy
Assignment from solve zone is probably one of the first preference of students.

January 29, 2015
This was nice in buy
Assignment from solve zone is probably one of the first preference of students.

21-Apr, 2018
This was nice in buy
Assignment from solve zone is probably one of the first preference of students.