Q. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

  • (A) data mining.
  • (B) data warehousing.
  • (C) web mining.
  • (D) text mining.
πŸ’¬ Discuss
βœ… Correct Answer: (B) data warehousing.

Q. The data Warehouse is__________.

  • (A) read only.
  • (B) write only.
  • (C) read write only.
  • (D) none.
πŸ’¬ Discuss
βœ… Correct Answer: (A) read only.

Q. Expansion for DSS in DW is__________.

  • (A) decision support system.
  • (B) decision single system.
  • (C) data storable system.
  • (D) data support system.
πŸ’¬ Discuss
βœ… Correct Answer: (A) decision support system.

Q. The important aspect of the data warehouse environment is that data found within the data warehouse is___________.

  • (A) subject-oriented.
  • (B) time-variant.
  • (C) integrated.
  • (D) all of the above.
πŸ’¬ Discuss
βœ… Correct Answer: (D) all of the above.

Q. The time horizon in Data warehouse is usually __________.

  • (A) 1-2 years.
  • (B) 3-4years.
  • (C) 5-6 years.
  • (D) 5-10 years.
πŸ’¬ Discuss
βœ… Correct Answer: (D) 5-10 years.

Q. The data is stored, retrieved & updated in ____________.

  • (A) olap.
  • (B) oltp.
  • (C) smtp.
  • (D) ftp.
πŸ’¬ Discuss
βœ… Correct Answer: (B) oltp.

Q. __________describes the data contained in the data warehouse.

  • (A) relational data.
  • (B) operational data.
  • (C) metadata.
  • (D) informational data.
πŸ’¬ Discuss
βœ… Correct Answer: (C) metadata.

Q. ____________predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions.

  • (A) data warehouse.
  • (B) data mining.
  • (C) datamarts.
  • (D) metadata.
πŸ’¬ Discuss
βœ… Correct Answer: (B) data mining.

Q. __________ is the heart of the warehouse.

  • (A) data mining database servers.
  • (B) data warehouse database servers.
  • (C) data mart database servers.
  • (D) relational data base servers.
πŸ’¬ Discuss
βœ… Correct Answer: (B) data warehouse database servers.

Q. ________________ is the specialized data warehouse database.

  • (A) oracle.
  • (B) dbz.
  • (C) informix.
  • (D) redbrick.
πŸ’¬ Discuss
βœ… Correct Answer: (D) redbrick.

Jump to