OLAP MCQ

Test your knowledge with important OLAP MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more OLAP MCQs at Bissoy

• State true or false: In OLAP, analysts cannot view a dimension in different levels of detail.
  ক

  True

  খ

  False
• The operation of moving from coarser granular data to finer granular data is called _______
  ক

  Reduction

  খ

  Increment

  গ

  Roll back

  ঘ

  Drill down
• State true or false: OLAP systems can be implemented as client-server systems
  ক

  True

  খ

  False
• Which of the following OLAP systems do not exist?
  ক

  HOLAP

  খ

  MOLAP

  গ

  ROLAP

  ঘ

  None of the mentioned
• The _______ function allows substitution of values in an attribute of a tuple
  ক

  Cube

  খ

  Unknown

  গ

  Decode

  ঘ

  Substitute
• How many dimensions of multi-dimensional data do cross tabs enable analysts to view?
  ক

  1

  খ

  2

  গ

  3

  ঘ

  None of the mentioned
• The operation of moving from finer granular data to coarser granular data is called _______
  ক

  Reduction

  খ

  Increment

  গ

  Roll up

  ঘ

  Drill down
• The operation of changing a dimensions used in a cross-tab is called as ________
  ক

  Alteration

  খ

  Pivoting

  গ

  Piloting

  ঘ

  Renewing
• Data that can be modelled as dimension attributes and measure attributes are called ___________
  ক

  Mono-dimensional data

  খ

  Multi-dimensional data

  গ

  Measurable data

  ঘ

  Efficient data
• What is the full form of OLAP?
  ক

  Online Application Programming

  খ

  Online Application Processing

  গ

  Online Analytical programming

  ঘ

  Online Analytical Processing
• Which one of the following is the right syntax for DECODE? … ) b) DECODE (expression, result … , search) c) DECODE (search, result … , expression) d) DECODE (expression, search, result … )
  ক

  DECODE (search, expression, result … )

  খ

  , search, result

  গ

  , search, result

  ঘ

  , search, result
• What do data warehouses support?
  ক

  OLAP

  খ

  OLTP

  গ

  OLAP and OLTP

  ঘ

  Operational databases
• In SQL the cross-tabs are created using
  ক

  Slice

  খ

  Dice

  গ

  Pivot

  ঘ

  All of the mentioned
• The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________
  ক

  Rollup

  খ

  Drill down

  গ

  Dicing

  ঘ

  Pivoting
• The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
  ক

  Slicing

  খ

  Dicing

  গ

  Pivoting

  ঘ

  Both Slicing and Dicing
• The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.
  ক

  Two dimensional cube

  খ

  Multidimensional cube

  গ

  N-dimensional cube

  ঘ

  Cuboid
• Data that can be modeled as dimension attributes and measure attributes are called _______ data.
  ক

  Multidimensional

  খ

  Singledimensional

  গ

  Measured

  ঘ

  Dimensional
• OLAP stands for
  ক

  Online analytical processing

  খ

  Online analysis processing

  গ

  Online transaction processing

  ঘ

  Online aggregate processing