On This Page

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

Q1 | Effect of one attribute value on a given class is independent of values of other attribute is called_________.
  • value independence.
  • class conditional independence.
  • conditional independence.
  • unconditional independence.
Q2 | The main organizational justification for implementing a data warehouse is to provide ______.
  • cheaper ways of handling transportation.
  • decision support.
  • storing large volume of data.
  • access to data.
Q3 | Multidimensional database is otherwise known as____________.
  • rdbms
  • dbms
  • extended rdbms
  • extended dbms
Q4 | Data warehouse architecture is based on ______________.
  • dbms.
  • rdbms.
  • sybase.
  • sql server.
Q5 | Source data from the warehouse comes from _______________.
  • ods.
  • tds.
  • mddb.
  • ordbms.
Q6 | ________________ is a data transformation process.
  • comparison.
  • projection.
  • selection.
  • filtering.
Q7 | The technology area associated with CRM is _______________.
  • specialization.
  • generalization.
  • personalization.
  • summarization.
Q8 | SMP stands for _______________.
  • symmetric multiprocessor.
  • symmetric multiprogramming.
  • symmetric metaprogramming.
  • symmetric microprogramming.
Q9 | __________ are designed to overcome any limitations placed on the warehouse by the nature of therelational data model.
  • operational database.
  • relational database.
  • multidimensional database.
  • data repository.
Q10 | MDDB stands for ___________.
  • multiple data doubling.
  • multidimensional databases.
  • multiple double dimension.
  • multi-dimension doubling.
Q11 | ______________ is data about data.
  • metadata.
  • microdata.
  • minidata.
  • multidata.
Q12 | ___________ is an important functional component of the metadata.
  • digital directory.
  • repository.
  • information directory.
  • data dictionary.
Q13 | EIS stands for ______________.
  • extended interface system.
  • executive interface system.
  • executive information system.
  • extendable information system.
Q14 | ___________ is data collected from natural systems.
  • mri scan.
  • ods data.
  • statistical data.
  • historical data.
Q15 | _______________ is an example of application development environments.
  • visual basic.
  • oracle.
  • sybase.
  • sql server.
Q16 | The term that is not associated with data cleaning process is ______.
  • domain consistency.
  • deduplication.
  • disambiguation.
  • segmentation.
Q17 | ____________ are some popular OLAP tools.
  • metacube, informix.
  • oracle express, essbase.
  • holap.
  • molap.
Q18 | Capability of data mining is to build ___________ models.
  • retrospective.
  • interrogative.
  • predictive.
  • imperative.
Q19 | _____________ is a process of determining the preference of customer's majority.
  • association.
  • preferencing.
  • segmentation.
  • classification.
Q20 | Strategic value of data mining is ______________.
  • cost-sensitive.
  • work-sensitive.
  • time-sensitive.
  • technical-sensitive.
Q21 | ____________ proposed the approach for data integration issues.
  • ralph campbell.
  • ralph kimball.
  • john raphlin.
  • james gosling.
Q22 | The terms equality and roll up are associated with ____________.
  • olap.
  • visualization.
  • data mart.
  • decision tree.
Q23 | Exceptional reporting in data warehousing is otherwise called as __________.
  • exception.
  • alerts.
  • errors.
  • bugs.
Q24 | ____________ is a metadata repository.
  • prism solution directory manager.
  • corba.
  • stunt.
  • cobweb.
Q25 | ________________ is an expensive process in building an expert system.
  • analysis.
  • study.
  • design.
  • information collection.