Data Mining And Warehouse Set 4

Computer Science Engineering (CSE),

Common Topics in Competitive and Entrance exams

Practice Mode Previous Next
On This Page

This set of Data Mining and Data Warehouse Multiple Choice Questions & Answers (MCQs) focuses on Data Mining And Warehouse Set 4

Q1 | The full form of KDD is _________.
  • knowledge database.
  • knowledge discovery in database.
  • knowledge data house.
  • knowledge data definition.
Answer: knowledge discovery in database.
Q2 | The first International conference on KDD was held in the year _____________.
  • 1996.
  • 1997.
  • 1995.
  • 1994.
Answer: 1995.
Q3 | Removing duplicate records is a process called _____________.
  • recovery.
  • data cleaning.
  • data cleansing.
  • data pruning.
Answer: data cleaning.
Q4 | ____________ contains information that gives users an easy-to-understand perspective of theinformation stored in the data warehouse.
  • business metadata.
  • technical metadata.
  • operational metadata.
  • financial metadata.
Answer: business metadata.
Q5 | _______________ helps to integrate, maintain and view the contents of the data warehousing system.
  • business directory.
  • information directory.
  • data dictionary.
  • database.
Answer: information directory.
Q6 | Discovery of cross-sales opportunities is called ________________.
  • segmentation.
  • visualization.
  • correction.
  • association.
Answer: association.
Q7 | Data marts that incorporate data mining tools to extract sets of data are called ______.
  • independent data mart.
  • dependent data marts.
  • intra-entry data mart.
  • inter-entry data mart.
Answer: dependent data marts.
Q8 | ____________ can generate programs itself, enabling it to carry out new tasks.
  • automated system.
  • decision making system.
  • self-learning system.
  • productivity system.
Answer: productivity system.
Q9 | The power of self-learning system lies in __________.
  • cost.
  • speed.
  • accuracy.
  • simplicity.
Answer: accuracy.
Q10 | Building the informational database is done with the help of _______.
  • transformation or propagation tools.
  • transformation tools only.
  • propagation tools only.
  • extraction tools.
Answer: transformation or propagation tools.
Q11 | How many components are there in a data warehouse?
  • two.
  • three.
  • four.
  • five.
Answer: five.
Q12 | Which of the following is not a component of a data warehouse?
  • metadata.
  • current detail data.
  • lightly summarized data.
  • component key.
Answer: component key.
Q13 | ________ is data that is distilled from the low level of detail found at the current detailed leve.
  • highly summarized data.
  • lightly summarized data.
  • metadata.
  • older detail data.
Answer: lightly summarized data.
Q14 | Highly summarized data is _______.
  • compact and easily accessible.
  • compact and expensive.
  • compact and hardly accessible.
  • compact.
Answer: compact and easily accessible.
Q15 | A directory to help the DSS analyst locate the contents of the data warehouse is seen in ______.
  • current detail data.
  • lightly summarized data.
  • metadata.
  • older detail data.
Answer: metadata.
Q16 | Metadata contains atleast _________.
  • the structure of the data.
  • the algorithms used for summarization.
  • the mapping from the operational environment to the data warehouse.
  • all of the above.
Answer: all of the above.
Q17 | Which of the following is not a old detail storage medium?
  • phot optical storage.
  • raid.
  • microfinche.
  • pen drive.
Answer: pen drive.
Q18 | The data from the operational environment enter _______ of data warehouse.
  • current detail data.
  • older detail data.
  • lightly summarized data.
  • highly summarized data.
Answer: current detail data.
Q19 | The data in current detail level resides till ________ event occurs.
  • purge.
  • summarization.
  • archieved.
  • all of the above.
Answer: all of the above.
Q20 | The dimension tables describe the _________.
  • entities.
  • facts.
  • keys.
  • units of measures.
Answer: facts.
Q21 | The granularity of the fact is the _____ of detail at which it is recorded.
  • transformation.
  • summarization.
  • level.
  • transformation and summarization.
Answer: level.
Q22 | Which of the following is not a primary grain in analytical modeling?
  • transaction.
  • periodic snapshot.
  • accumulating snapshot.
  • all of the above.
Answer: periodic snapshot.
Q23 | Granularity is determined by ______.
  • number of parts to a key.
  • granularity of those parts.
  • both a and b.
  • none of the above.
Answer: both a and b.
Q24 | ___________ of data means that the attributes within a given entity are fully dependent on the entireprimary key of the entity.
  • additivity.
  • granularity.
  • functional dependency.
  • dimensionality.
Answer: functional dependency.
Q25 | A fact is said to be fully additive if ___________.
  • it is additive over every dimension of its dimensionality.
  • additive over atleast one but not all of the dimensions.
  • not additive over any dimension.
  • none of the above.
Answer: it is additive over every dimension of its dimensionality.
Previous Next