Data Mining and Data Warehouse MCQs with answers Page - 3

Here, you will find a collection of MCQ questions on Data Mining and Data Warehouse. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 828.03K Points
Coach

Q. Record cannot be updated in _____________.

  • (A) oltp
  • (B) files
  • (C) rdbms
  • (D) data warehouse

A

Admin • 828.03K Points
Coach

Q. The source of all data warehouse data is the____________.

  • (A) operational environment.
  • (B) informal environment.
  • (C) formal environment.
  • (D) technology environment.

A

Admin • 828.03K Points
Coach

Q. Data warehouse contains_____________data that is never found in the operational environment.

  • (A) normalized.
  • (B) informational.
  • (C) summary.
  • (D) denormalized.

A

Admin • 828.03K Points
Coach

Q. The modern CASE tools belong to _______ category.

  • (A) analysis.
  • (B) development
  • (C) coding
  • (D) delivery

A

Admin • 828.03K Points
Coach

Q. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process.

  • (A) 10 percent.
  • (B) 20 percent.
  • (C) 40 percent
  • (D) 80 percent.

A

Admin • 828.03K Points
Coach

Q. Detail data in single fact table is otherwise known as__________.

  • (A) monoatomic data.
  • (B) diatomic data.
  • (C) atomic data.
  • (D) multiatomic data.

A

Admin • 828.03K Points
Coach

Q. _______test is used in an online transactional processing environment.

  • (A) mega.
  • (B) micro.
  • (C) macro.
  • (D) acid.

A

Admin • 828.03K Points
Coach

Q. ___________ is a good alternative to the star schema.

  • (A) star schema.
  • (B) snowflake schema.
  • (C) fact constellation.
  • (D) star-snowflake schema.

A

Admin • 828.03K Points
Coach

Q. The biggest drawback of the level indicator in the classic star-schema is that it limits_________.

  • (A) quantify.
  • (B) qualify.
  • (C) flexibility.
  • (D) ability.

A

Admin • 828.03K Points
Coach

Q. A data warehouse is _____________.

  • (A) updated by end users.
  • (B) contains numerous naming conventions and formats
  • (C) organized around important subject areas.
  • (D) contains only current data.

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.