hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    Which of the following integrity constraints ensures that no duplicate rows are present in a table?
    Question



    Which of the following integrity constraints ensures that no duplicate rows are present in a table?

    A.

    Foreign Key Constraint

    B.

    Unique Constraint

    C.

    Not Null Constraint

    D.

    Primary Key Constraint

    E.

    Check Constraint

    Correct option is D

    The Primary Key Constraint ensures that every row in a table is unique and identifiable. It prevents duplicate rows and enforces the uniqueness and not null properties on the specified column(s).
    Example:

    Important Key Points:
    1. A primary key is a combination of Unique and Not Null constraints.
    2. Each table can have only one primary key, but it can consist of multiple columns (composite primary key).
    Knowledge Booster:
    · Foreign Key: Ensures referential integrity between two tables.
    · Unique Constraint: Enforces uniqueness but allows NULL values.
    · Not Null Constraint: Ensures that a column cannot have NULL values.
    · Check Constraint: Ensures that a column satisfies a specific condition.

    Free Tests

    Free
    Must Attempt
    Video Solutions

    RBI Assistant Pre 2026 Full Mock Test -01

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon100 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt
    Video Solutions

    RBI Asst Prelims 2026 : Reasoning Section Test 01

    languageIcon English
    • pdpQsnIcon35 Questions
    • pdpsheetsIcon35 Marks
    • timerIcon20 Mins
    languageIcon English
    Free
    Must Attempt
    Video Solutions

    RBI Asst Prelims 2026 : Quant Section Test 01

    languageIcon English
    • pdpQsnIcon35 Questions
    • pdpsheetsIcon35 Marks
    • timerIcon20 Mins
    languageIcon English
    test-prime-package

    Access ‘SEBI Grade-A Assistant Manager’ Mock Tests with

    • 60000+ Mocks and Previous Year Papers
    • Unlimited Re-Attempts
    • Personalised Report Card
    • 500% Refund on Final Selection
    • Largest Community
    students-icon
    368k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow