Related Topics
Take Another Quiz

Data Modeling Test1

15 Questions
Data Modeling Test1

Test your understanding of Data Modeling concepts

Questions and Answers
  • 1. 
    Data Modeler focus on what operation performed on the data  rather than requirement of the data
    • A. 

      True

    • B. 

      False

  • 2. 
    Information in the data model are applied to define
    • A. 

      Requirements

    • B. 

      Data type and length of the column

    • C. 

      Primary and foreign keys

    • D. 

      RDBMS used to store the data

  • 3. 
    Data Model helps not store the redundant data
    • A. 

      True

    • B. 

      False

  • 4. 
    • A. 

      True

    • B. 

      False

  • 5. 
    • A. 

      What data is going to store

    • B. 

      The relationship between the tables

    • C. 

      Part of the data in the table

    • D. 

      How data is going to store

  • 6. 
    An OLTP data base is designed to handle the day to day needs of a business
    • A. 

      True

    • B. 

      False

  • 7. 
    Online Analytical Processing is also called as
    • A. 

      Decision support processing

    • B. 

      On line transctional processing

    • C. 

      Transction control processing

    • D. 

      Concurrent control processing

  • 8. 
    Dimensional model holds current data
    • A. 

      True

    • B. 

      False

  • 9. 
    OLTP stores detail level of data
    • A. 

      True

    • B. 

      False

  • 10. 
                 The following data base table design is an   example of ---------------------------------                                                                                                  
    PRODUCT
       Product Identifier(PK)
    Product Category Name Product subCategory Name Product  Name Product  Feature Description
           
    LOCATION
          Location  Identifier(PK)
    Country Name State  Name city  Name ate Timestamp
                                      
      Sales
    Organization  Identifier(PK) Product Identifier(PK) Location  Identifier(PK)
    Sales DollarAverage sales Date and Timestamp
                                                                                                                                              
    Organization
    Organization  Identifier(PK)
    Corporate office Name Region  Name Brach  Name Employer Name Date and Timestamp
                                                                              
    • A. 

      Online transaction processing model

    • B. 

      Dimensional model

    • C. 

      Unable to interpret with the input data

    • D. 

      None of the above

  • 11. 
    • A. 

      Dimensional model

    • B. 

      Online transaction processing model

    • C. 

      It can be either Dimensional model or Online transaction processing model

    • D. 

      None of the above

  • 12. 
    Dimensional table stores records related to that particular  dimension and no measures are stored  in these tables
    • A. 

      True

    • B. 

      False

  • 13. 
    Data modellinData modelling is the process of constructingg is the process of constructing
    • A. 

      An orderly arrangement of data elements

    • B. 

      A graphic representation of data contained in an information system

    • C. 

      Physical elements of the information system

    • D. 

      A verbal description of the data need

  • 14. 
    • A. 

      True

    • B. 

      False

  • 15. 
    Logical Data model  does not contain much detail level of information about the attributes
    • A. 

      True

    • B. 

      False