Data Mining and Data Warehouse MCQ Questions with answers and solutions Page 6

Q. Effect of one attribute value on a given class is independent of values of other attribute is called _________.

(A) value independence.
(B) class conditional independence.
(C) conditional independence.
(D) unconditional independence.

💬 Discuss

✅ Correct Answer: (A) value independence.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. The main organizational justification for implementing a data warehouse is to provide ______.

(A) cheaper ways of handling transportation.
(B) decision support.
(C) storing large volume of data.
(D) access to data.

💬 Discuss

✅ Correct Answer: (C) storing large volume of data.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. Multidimensional database is otherwise known as____________.

(A) rdbms
(B) dbms
(C) extended rdbms
(D) extended dbms

💬 Discuss

✅ Correct Answer: (B) dbms

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. Data warehouse architecture is based on ______________.

(A) dbms.
(B) rdbms.
(C) sybase.
(D) sql server.

💬 Discuss

✅ Correct Answer: (B) rdbms.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. Source data from the warehouse comes from _______________.

(A) ods.
(B) tds.
(C) mddb.
(D) ordbms.

💬 Discuss

✅ Correct Answer: (A) ods.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. ________________ is a data transformation process.

(A) comparison.
(B) projection.
(C) selection.
(D) filtering.

💬 Discuss

✅ Correct Answer: (D) filtering.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. The technology area associated with CRM is _______________.

(A) specialization.
(B) generalization.
(C) personalization.
(D) summarization.

💬 Discuss

✅ Correct Answer: (C) personalization.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. SMP stands for _______________.

(A) symmetric multiprocessor.
(B) symmetric multiprogramming.
(C) symmetric metaprogramming.
(D) symmetric microprogramming.

💬 Discuss

✅ Correct Answer: (A) symmetric multiprocessor.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. __________ are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.

(A) operational database.
(B) relational database.
(C) multidimensional database.
(D) data repository.

💬 Discuss

✅ Correct Answer: (C) multidimensional database.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Q. MDDB stands for ___________.

(A) multiple data doubling.
(B) multidimensional databases.
(C) multiple double dimension.
(D) multi-dimension doubling.

💬 Discuss

✅ Correct Answer: (B) multidimensional databases.

Published by Mr. Dubey ⭐ 109.51K Points at 14-Jun-2020 11:59 am in Data Mining and Data Warehouse

Jump to