• Answer the following questions:
  • What are the objectives of selecting a data type for a field?
  • Explain why you sometimes must reserve much more space for a numeric field than any of the initial stored values requires.
  • Explain why normalize relations may not be the most efficient design.
  • Explain why an index is useful only if there is sufficient variety in the values of an attribute.
  • What is the difference between a dynamic view and a materialized view?
  • List six potential benefits of having in SQL standard that is widely accepted.