Skip to main content

Unit 1: MCQ Bank

A collection of 20 essential multiple-choice questions for Unit 1: Data Warehouse, complete with supporting statements for quick revision.

Questions and Answers​

1. OLTP stands for​

  • Answer: A. On-Line Transactional Processing
  • Support: OLTP systems handle real-time transactional data like banking, booking, etc.

2. Data warehouse is​

  • Answer: C. A subject-oriented integrated time-variant non-volatile collection of data in support of management
  • Support: This is the standard definition by Bill Inmon.

3. A data warehouse is which of the following?​

  • Answer: C. Organized around important subject areas
  • Support: Data warehouse is subject-oriented (e.g., sales, customers), not process-oriented.

4. __ is a subject-oriented, integrated, time-variant, non-volatile collection of data​

  • Answer: B. Data Warehousing
  • Support: The core definition of a Data Warehouse.

5. The data Warehouse is​

  • Answer: A. read only
  • Support: Data warehouse is non-volatile, meaning data is not updated frequently after being loaded.

6. Expansion for DSS in DW is​

  • Answer: A. Decision Support System
  • Support: DSS helps managers make data-driven decisions using warehouse information.

7. Important aspect of data warehouse data is​

  • Answer: D. All of the above
  • Support: Includes being subject-oriented, integrated, and time-variant.

8. Time horizon in Data warehouse is usually​

  • Answer: D. 5-10 years
  • Support: Stores long-term historical data for trend analysis.

9. Data is stored, retrieved & updated in​

  • Answer: B. OLTP
  • Support: OLTP systems are optimized for frequent insert, update, and delete operations.

10. __ describes the data in data warehouse​

  • Answer: C. Metadata
  • Support: Metadata is “data about data,” defining the schema, structure, and meaning.

11. __ databases are owned by departments​

  • Answer: B. Operational
  • Support: Operational databases are typically department-specific (e.g., HR, Sales).

12. Star schema is composed of fact table​

  • Answer: A. one
  • Support: A star schema features one central fact table linked to multiple dimension tables.

13. Time horizon in operational environment is​

  • Answer: A. 30-60 days
  • Support: Operational systems focus on current or very recent transactional data.

14. Key in operational environment may not have element of​

  • Answer: A. time
  • Support: Keys in OLTP systems focus on unique transaction identification, not necessarily historical time tracking.

15. Data can be updated in __ environment​

  • Answer: C. operational
  • Support: OLTP/Operational systems allow for regular and frequent data updates.

16. Record cannot be updated in​

  • Answer: D. data warehouse
  • Support: Due to its non-volatile nature, records in a data warehouse are generally not updated.

17. Relationship in star schema is​

  • Answer: C. one-to-many
  • Support: One record in a dimension table typically relates to many records in the fact table.

18. Fact tables are​

  • Answer: B. partially denormalized
  • Support: Fact tables are optimized for query performance rather than strict normalization.

19. Data warehouse architecture is based on​

  • Answer: B. RDBMS
  • Support: Most warehouses are implemented using Relational Database Management Systems.

20. __ is data about data​

  • Answer: A. Metadata
  • Support: Defines the overall structure, schema, and meaning of the data within the warehouse.