Data Warehousing and Mining MCQs Questions and Answers Pdf

21. Record cannot be updated in _____________.
A. OLTP
B. files
C. RDBMS
D. data warehouse

ANSWER:
D

22. The source of all data warehouse data is the____________.
A. operational environment.
B. informal environment.
C. formal environment.
D. technology environment.

ANSWER:
A

23. Data warehouse contains_____________data that is never found in the operational environment.
A. normalized.
B. informational.
C. summary.
D. denormalized.

ANSWER:
C



24. The modern CASE tools belong to _______ category.
A. a. analysis.
B. b.Development
C. c.Coding
D. d.Delivery

ANSWER:
A

25. 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. 40 percent
D. 80 percent.

ANSWER:
D

26. Detail data in single fact table is otherwise known as__________.
A. monoatomic data.
B. diatomic data.
C. atomic data.
D. multiatomic data.

ANSWER:
C




27. _______test is used in an online transactional processing environment.
A. MEGA.
B. MICRO.
C. MACRO.
D. ACID.

ANSWER:
D

28. ___________ is a good alternative to the star schema.
A. Star schema.
B. Snowflake schema.
C. Fact constellation.
D. Star-snowflake schema.

ANSWER:
C

29. The biggest drawback of the level indicator in the classic star-schema is that it limits_________.
A. quantify.
B. qualify.
C. flexibility.
D. ability.

ANSWER:
C

30. 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.

ANSWER:
C