Data Mining and Data Warehouse MCQs with answers Page - 2

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. ________________defines the structure of the data held in operational databases and used by operational applications.

  • (A) user-level metadata.
  • (B) data warehouse metadata.
  • (C) operational metadata.
  • (D) data mining metadata.

A

Admin • 828.03K Points
Coach

Q. ________________ is held in the catalog of the warehouse database system.

  • (A) application level metadata.
  • (B) algorithmic level metadata.
  • (C) departmental level metadata.
  • (D) core warehouse metadata.

A

Admin • 828.03K Points
Coach

Q. _________maps the core warehouse metadata to business concepts, familiar and useful to end users.

  • (A) application level metadata.
  • (B) user level metadata.
  • (C) enduser level metadata.
  • (D) core level metadata.

A

Admin • 828.03K Points
Coach

Q. ______consists of formal definitions, such as a COBOL layout or a database schema.

  • (A) classical metadata.
  • (B) transformation metadata.
  • (C) historical metadata.
  • (D) structural metadata.

A

Admin • 828.03K Points
Coach

Q. _____________consists of information in the enterprise that is not in classical form.

  • (A) mushy metadata.
  • (B) differential metadata.
  • (C) data warehouse.
  • (D) data mining.

A

Admin • 828.03K Points
Coach

Q. . ______________databases are owned by particular departments or business groups.

  • (A) informational.
  • (B) operational.
  • (C) both informational and operational.
  • (D) flat.

A

Admin • 828.03K Points
Coach

Q. The star schema is composed of __________ fact table.

  • (A) one.
  • (B) two.
  • (C) three.
  • (D) four.

A

Admin • 828.03K Points
Coach

Q. The time horizon in operational environment is ___________.

  • (A) 30-60 days.
  • (B) 60-90 days.
  • (C) 90-120 days.
  • (D) 120-150 days.

A

Admin • 828.03K Points
Coach

Q. The key used in operational environment may not have an element of__________.

  • (A) time.
  • (B) cost.
  • (C) frequency.
  • (D) quality.

A

Admin • 828.03K Points
Coach

Q. Data can be updated in _____environment.

  • (A) data warehouse.
  • (B) data mining.
  • (C) operational.
  • (D) informational.

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.