Data Mining And Warehouse Set 1
On This Page
This set of Data Mining and Data Warehouse Multiple Choice Questions & Answers (MCQs) focuses on Data Mining And Warehouse Set 1
Q1 | __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support ofmanagement decisions.
- data mining.
- data warehousing.
- web mining.
- text mining.
Q2 | The data Warehouse is__________.
- read only.
- write only.
- read write only.
- none.
Q3 | Expansion for DSS in DW is__________.
- decision support system.
- decision single system.
- data storable system.
- data support system.
Q4 | The important aspect of the data warehouse environment is that data found within the data warehouseis___________.
- subject-oriented.
- time-variant.
- integrated.
- all of the above.
Q5 | The time horizon in Data warehouse is usually __________.
- 1-2 years.
- 3-4years.
- 5-6 years.
- 5-10 years.
Q6 | The data is stored, retrieved & updated in ____________.
- olap.
- oltp.
- smtp.
- ftp.
Q7 | __________describes the data contained in the data warehouse.
- relational data.
- operational data.
- metadata.
- informational data.
Q8 | ____________predicts future trends & behaviors, allowing business managers to make proactive,knowledge-driven decisions.
- data warehouse.
- data mining.
- datamarts.
- metadata.
Q9 | __________ is the heart of the warehouse.
- data mining database servers.
- data warehouse database servers.
- data mart database servers.
- relational data base servers.
Q10 | ________________ is the specialized data warehouse database.
- oracle.
- dbz.
- informix.
- redbrick.
Q11 | ________________defines the structure of the data held in operational databases and used byoperational applications.
- user-level metadata.
- data warehouse metadata.
- operational metadata.
- data mining metadata.
Q12 | ________________ is held in the catalog of the warehouse database system.
- application level metadata.
- algorithmic level metadata.
- departmental level metadata.
- core warehouse metadata.
Q13 | _________maps the core warehouse metadata to business concepts, familiar and useful to end users.
- application level metadata.
- user level metadata.
- enduser level metadata.
- core level metadata.
Q14 | ______consists of formal definitions, such as a COBOL layout or a database schema.
- classical metadata.
- transformation metadata.
- historical metadata.
- structural metadata.
Q15 | _____________consists of information in the enterprise that is not in classical form.
- mushy metadata.
- differential metadata.
- data warehouse.
- data mining.
Q16 | . ______________databases are owned by particular departments or business groups.
- informational.
- operational.
- both informational and operational.
- flat.
Q17 | The star schema is composed of __________ fact table.
- one.
- two.
- three.
- four.
Q18 | The time horizon in operational environment is ___________.
- 30-60 days.
- 60-90 days.
- 90-120 days.
- 120-150 days.
Q19 | The key used in operational environment may not have an element of__________.
- time.
- cost.
- frequency.
- quality.
Q20 | Data can be updated in _____environment.
- data warehouse.
- data mining.
- operational.
- informational.
Q21 | Record cannot be updated in _____________.
- oltp
- files
- rdbms
- data warehouse
Q22 | The source of all data warehouse data is the____________.
- operational environment.
- informal environment.
- formal environment.
- technology environment.
Q23 | Data warehouse contains_____________data that is never found in the operational environment.
- normalized.
- informational.
- summary.
- denormalized.
Q24 | The modern CASE tools belong to _______ category.
- a. analysis.
- b.development
- c.coding
- d.delivery
Q25 | Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed inthe conversion process.
- 10 percent.
- 20 percent.
- 40 percent
- 80 percent.