Data Mining and Data Warehouse MCQs with answers Page - 5

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 • 831.35K Points
Coach

Q. Fact tables are ___________.

  • (A) completely demoralized.
  • (B) partially demoralized.
  • (C) completely normalized.
  • (D) partially normalized.

A

Admin • 831.35K Points
Coach

Q. _______________ is the goal of data mining.

  • (A) to explain some observed event or condition.
  • (B) to confirm that data exists.
  • (C) to analyze data for expected relationships.
  • (D) to create a new data warehouse.

A

Admin • 831.35K Points
Coach

Q. Business Intelligence and data warehousing is used for ________.

  • (A) forecasting.
  • (B) data mining.
  • (C) analysis of large volumes of product sales data.
  • (D) all of the above.

A

Admin • 831.35K Points
Coach

Q. The data administration subsystem helps you perform all of the following, except__________.

  • (A) backups and recovery.
  • (B) query optimization.
  • (C) security management.
  • (D) create, change, and delete information.

A

Admin • 831.35K Points
Coach

Q. The most common source of change data in refreshing a data warehouse is _______.

  • (A) queryable change data.
  • (B) cooperative change data.
  • (C) logged change data.
  • (D) snapshot change data.

A

Admin • 831.35K Points
Coach

Q. ________ are responsible for running queries and reports against data warehouse tables.

  • (A) hardware.
  • (B) software.
  • (C) end users.
  • (D) middle ware.

A

Admin • 831.35K Points
Coach

Q. Query tool is meant for __________.

  • (A) data acquisition.
  • (B) information delivery.
  • (C) information exchange.
  • (D) communication.

A

Admin • 831.35K Points
Coach

Q. Classification rules are extracted from _____________.

  • (A) root node.
  • (B) decision tree.
  • (C) siblings.
  • (D) branches.

A

Admin • 831.35K Points
Coach

Q. Dimensionality reduction reduces the data set size by removing ____________.

  • (A) relevant attributes.
  • (B) irrelevant attributes.
  • (C) derived attributes.
  • (D) composite attributes.

A

Admin • 831.35K Points
Coach

Q. ___________ is a method of incremental conceptual clustering.

  • (A) corba.
  • (B) olap.
  • (C) cobweb.
  • (D) sting.

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.