Data Warehousing MCQ Questions and Answers Quiz

41. Record cannot be updated in

  1. OLTP
  2. files
  3. RDBMS
  4. data warehouse

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

  1. one.
  2. two.
  3. three.
  4. four.

43. The full form of OLAP is

  1. Online Analytical Processing
  2. Online Advanced Processing
  3. Online Advanced Preparation
  4. Online Analytical Performance

44. The source of all data warehouse data is the

  1. operational environment.
  2. informal environment.
  3. formal environment.
  4. technology environment.

45. ________________ is the specialized data warehouse database.

  1. Oracle.
  2. DBZ.
  3. Informix.
  4. Redbrick.

46. The biggest drawback of the level indicator in the classic star-schema is that it limits

  1. quantify.
  2. qualify.
  3. flexibility.
  4. ability.

47. The data Warehouse is

  1. read only
  2. write only
  3. read write only
  4. none

48. __________describes the data contained in the data warehouse.

  1. Relational data.
  2. Operational data.
  3. Metadata.
  4. Informational data.

49. ........................ is a good alternative to the star schema.

  1. Star schema
  2. Snowflake schema
  3. Fact constellation
  4. Star-snowflake schema

50. ___________ is a good alternative to the star schema.

  1. Star schema.
  2. Snowflake schema.
  3. Fact constellation.
  4. Star-snowflake schema.
Tags

MCQ Multiple Choice Questions and Answers on Data Warehousing

Data Warehousing Question and Answer