Dmw-quiz-1-a

15 Questions | Total Attempts: 249

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

Questions and Answers
  • 1. 
    ________________defines the structure of the data held in operational databases .
    • A. 

      User-level metadata.

    • B. 

      Transaction Data

    • C. 

      Operational metadata.

    • D. 

      Data mining metadata.

  • 2. 
    The star schema is composed of __________ fact table.
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 3. 
    The source of all data warehouse data is the____________.
    • A. 

      Operational environment.

    • B. 

      Informal environment.

    • C. 

      Formal environment.

    • D. 

      Technology environment.

  • 4. 
    Data warehouse contains_____________data that is never found in the operational environment.
    • A. 

      Normalized.

    • B. 

      Informational.

    • C. 

      Summary.

    • D. 

      Denormalized.

  • 5. 
    Relation between mean, median and mode
    • A. 

      Mean- mode = 2(mean-median)

    • B. 

      Mean- median = 3(mean-mode)

    • C. 

      Mean- mode = 3(mean-median)

    • D. 

      Mean- median = 2(mean-mode)

  • 6. 
    For Quick Searching …………………………………indexing is used in OLAP cube
    • A. 

      Bitmap

    • B. 

      Joint Bitmap

    • C. 

      Composite join Indices

    • D. 

      None of the above

  • 7. 
    To Store and Manage warehouse data we use ……………..OLAP
    • A. 

      HOLAP

    • B. 

      MOLAP

    • C. 

      ROLAP

    • D. 

      SQL Servers

  • 8. 
    ……………………………perfroms selection on One Dimensions of the Given Cube
    • A. 

      Pivot

    • B. 

      SLICE

    • C. 

      DICE

    • D. 

      Drill-Down

  • 9. 
    Sequencing of the mappings from a set of low-level concepts to higher-level concepts is known as
    • A. 

      Data mart

    • B. 

      Data warehouse

    • C. 

      Star schema

    • D. 

      Concept Hierarchy

  • 10. 
    The model is kept in the normalized form in ……………….Schema
    • A. 

      Fact Constellation

    • B. 

      Snow Flake

    • C. 

      Star schema

    • D. 

      None of the above

  • 11. 
    Data to be modeled is multiple dimensions in
    • A. 

      Data Cube

    • B. 

      Data Mart

    • C. 

      Data Model

    • D. 

      Dimension table

  • 12. 
    Data Cleaning is used to
    • A. 

      Detect errors in data and rectifies

    • B. 

      Propagates updates from the data sources to the warehouse

    • C. 

      Converts data from legacy formats to warehouse format

    • D. 

      Gather data from Multiple, heterogeneous resources

  • 13. 
    Data warehouse has
    • A. 

      4-Tiers

    • B. 

      3-Tiers

    • C. 

      2-Tiers

    • D. 

      N-Tiers

  • 14. 
    Data are extracted using application program interfaces are known as
    • A. 

      Hubs

    • B. 

      Processcors

    • C. 

      Switches

    • D. 

      Gateways

  • 15. 
    OLAP is
    • A. 

      Informational Processing

    • B. 

      Lots of Scans

    • C. 

      Summarized & Consolidated

    • D. 

      All of the above

Related Topics
Back to Top Back to top