Data Mining and Business Intelligence MCQs with answers Page - 3

Here, you will find a collection of MCQ questions on Data Mining and Business Intelligence. 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) 30 percent
  • (D) 40 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 thatit 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.