📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      Question

      In Database Management Systems, what is the primary

      purpose of normalization?
      A To ensure data redundancy Correct Answer Incorrect Answer
      B To improve data security Correct Answer Incorrect Answer
      C To eliminate data redundancy Correct Answer Incorrect Answer
      D To enforce data consistency Correct Answer Incorrect Answer
      E To enhance query performance Correct Answer Incorrect Answer

      Solution

      Normalization in Database Management Systems (DBMS) aims to eliminate data redundancy by organizing data into well-structured tables. This process involves breaking down a database into smaller, non-redundant tables while maintaining relationships between them. Normalization also improves data integrity and ensures that anomalies like insert, update, and delete anomalies are minimized. To ensure data redundancy : Normalization eliminates, not ensures, redundancy. To improve data security : While normalization improves data integrity, it is not specifically focused on security. To enforce data consistency : Although normalization contributes to consistency, its primary goal is to eliminate redundancy. To enhance query performance : While normalization can sometimes improve performance, the main goal is reducing redundancy.

      Practice Next
      More Algorithms Questions
      ask-question