New IFSCA Phase 1 Results Out - Enroll Here for Phase 2

    Register

    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