Skip to main content

Quiz

  1. What is Data Normalization?
  2. What is Data Denormalization?
  3. What are the Pros and Cons of Data Normalization?
  4. What are the Pros and Cons of Data Denormalization?
  5. What is the difference among 1NF, 2NF and 3NF?
  6. What are the different categories of NoSQL Databases?
  7. What are the ACID properties and where these are applied?
  8. What are the BASE properties and where these are applied?
  9. What are the differences between SQL and NoSQL data modeling?
  10. What is OLTP?
  11. What is OLAP?
  12. What are the differences between OLTP and OLAP?
  13. What are the Pros and Cons of OLTP?
  14. What are the Pros and Cons of OLAP?
  15. What is CAP theorem?
  16. What is Data Modeling and Why you should care?
  17. What are the advantages of Data Modeling?
  18. What is Conceptual Data Model?
  19. What is Logical Data Model?
  20. What is Physical Data Model?
  21. What is Entity-Relation (ER) Model?
  22. What is Star Schema?
  23. What are the differences between Star Schema and Snowflake Schema?
  24. Explain the Relational Data Modeling with an example
  25. Explain the Non-Relational Data Modeling with an example
  26. Explain the Kimball's Four Step Process to Dimensional Data Modeling
  27. What is Inmon Data Modeling Approach?
  28. What are the differences between Kimball and Inmon Data Modeling Approach?
  29. What is the difference between Fact and Dimension Tables?
  30. What are Slowly Changing Dimensions (SCDs)?
  31. Explain Different Types of Slowly Changing Dimensions (SCDs)
  32. What is Data Warehouse?
  33. Why is Data Warehouse needed?
  34. What are the differences between Databases and Data Warehouses?
  35. What are the differences between Operational and Analytical Systems?
  36. What is Data Mart?
  37. Explain how the Cargo Shipping Company Created its Data Model?