Can a database contain two identical records without a negat

Can a database contain two identical records without a negative effect on the integrity of the database? Why or why not?

Solution

Yes, we can have a database containing two identical records without a negative effect on the integrity of the database.

for example, let say we have maintained a database containing all records related to a survey conducted and there is a high chance of having two or more identical records.

We can have two or more identical records but with different Primary key. but if we insert a new row with the similar primary key, it will throw an error , depending on the database which you are using. It will violate the primary key constraint.