placeholder image to represent content

Data Warehouse MCQ

Quiz by Roseline Vaseehar

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    The full form of OLAP is
    Online Advanced Processing
    Online Advanced Preparation
    Online Analytical Processing
    Online Analytical Performance
    20s
  • Q2
    __________is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
    Data Mining
    Document Mining
    Data Warehousing
    Text Mining
    20s
  • Q3
    The data is stored, retrieved and updated in
    SMTP
    OLTP
    OLAP
    KDD
    20s
  • Q4
    An ___________ system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.
    OLTP
    OLAP
    Both of the above
    None of the above
    20s
  • Q5
    ___________ is a good alternative to the star schema.
    Fact constellation
    Snowflake schema
    Star-snowflake schema
    Star schema
    20s
  • Q6
    Data modeling technique used for data marts is
    Dimensional modeling
    Extended ER model
    Schema
    ER Model
    20s
  • Q7
    The data from the operational environment enter _______ of data warehouse.
    Lightly summarized data
    Older detail data
    Current detail data
    Highly summarized data
    20s
  • Q8
    The data Warehouse is__________.
    Read Only
    None
    Write Only
    Read Write Only
    20s
  • Q9
    Rollup is aslo known as
    Regression
    Consolation
    Increasing a dimension
    Aggregation
    20s
  • Q10
    The Slice operation select ____________ dimension from a given cube.
    2
    1
    0
    More
    20s

Teachers give this quiz to your class