Data Warehouse Set 2

Other topics

Practice Mode Previous Next
On This Page

This set of Data Warehouse Multiple Choice Questions & Answers (MCQs) focuses on Data Warehouse Set 2

Q1 | ___________ is a method of incremental conceptual clustering.
  • CORBA.
  • OLAP.
  • COBWEB.
  • STING.
Answer: COBWEB.
Q2 | 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.
Answer: value independence.
Q3 | The main organizational justification for implementing a data warehouse is toprovide ______.
  • cheaper ways of handling transportation.
  • decision support.
  • storing large volume of data.
  • access to data.
Answer: storing large volume of data.
Q4 | Multidimensional database is otherwise known as____________.
  • RDBMS
  • DBMS
  • EXTENDED RDBMS
  • EXTENDED DBMS
Answer: DBMS
Q5 | Data warehouse architecture is based on ______________.
  • DBMS.
  • RDBMS.
  • Sybase.
  • SQL Server.
Answer: RDBMS.
Q6 | Source data from the warehouse comes from _______________.
  • ODS.
  • TDS.
  • MDDB.
  • ORDBMS.
Answer: ODS.
Q7 | ________________ is a data transformation process.
  • Comparison.
  • Projection.
  • Selection.
  • Filtering.
Answer: Filtering.
Q8 | The technology area associated with CRM is _______________.
  • specialization.
  • generalization.
  • personalization.
  • summarization.
Answer: personalization.
Q9 | SMP stands for _______________.
  • Symmetric Multiprocessor.
  • Symmetric Multiprogramming.
  • Symmetric Metaprogramming.
  • Symmetric Microprogramming.
Answer: Symmetric Multiprocessor.
Q10 | __________ are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.
  • Operational database.
  • Relational database.
  • Multidimensional database.
  • Data repository.
Answer: Multidimensional database.
Q11 | MDDB stands for ___________.
  • multiple data doubling.
  • multidimensional databases.
  • multiple double dimension.
  • multi-dimension doubling.
Answer: multidimensional databases.
Q12 | ______________ is data about data.
  • Metadata.
  • Microdata.
  • Minidata.
  • Multidata.
Answer: Metadata.
Q13 | ___________ is an important functional component of the metadata.
  • Digital directory.
  • Repository.
  • Information directory.
  • Data dictionary.
Answer: Information directory.
Q14 | EIS stands for ______________.
  • Extended interface system.
  • Executive interface system.
  • Executive information system.
  • Extendable information system.
Answer: Executive information system.
Q15 | ___________ is data collected from natural systems.
  • MRI scan.
  • ODS data.
  • Statistical data.
  • Historical data.
Answer: MRI scan.
Q16 | _______________ is an example of application development environments.
  • Visual Basic.
  • Oracle.
  • Sybase.
  • SQL Server.
Answer: Visual Basic.
Q17 | The term that is not associated with data cleaning process is ______.
  • domain consistency.
  • deduplication.
  • disambiguation.
  • segmentation.
Answer: segmentation.
Q18 | ____________ are some popular OLAP tools.
  • Metacube, Informix.
  • Oracle Express, Essbase.
  • HOLAP.
  • MOLAP.
Answer: Metacube, Informix.
Q19 | Capability of data mining is to build ___________ models.
  • retrospective.
  • interrogative.
  • predictive.
  • imperative.
Answer: predictive.
Q20 | _____________ is a process of determining the preference of customer's majority.
  • Association.
  • Preferencing.
  • Segmentation.
  • Classification.
Answer: Preferencing.
Q21 | Strategic value of data mining is ______________.
  • cost-sensitive.
  • work-sensitive.
  • time-sensitive.
  • technical-sensitive.
Answer: time-sensitive.
Q22 | ____________ proposed the approach for data integration issues.
  • Ralph Campbell.
  • Ralph Kimball.
  • John Raphlin.
  • James Gosling.
Answer: Ralph Kimball.
Q23 | The terms equality and roll up are associated with ____________.
  • OLAP.
  • visualization.
  • data mart.
  • decision tree.
Answer: data mart.
Q24 | Exceptional reporting in data warehousing is otherwise called as __________.
  • exception.
  • alerts.
  • errors.
  • bugs.
Answer: alerts.
Q25 | ____________ is a metadata repository.
  • Prism solution directory manager.
  • CORBA.
  • STUNT.
  • COBWEB.
Answer: Prism solution directory manager.
Previous Next