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 Office Attendant 2026 Full Mock Test - 01

languageIcon English
  • pdpQsnIcon120 Questions
  • pdpsheetsIcon120 Marks
  • timerIcon90 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
354k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow