Computer Science Ques 491

Question: Which of the following types of tables constraints will prevent the entry of duplicate rows?

Options:

A) Primary key

B) Unique

C) Null

D) foreign key

E) None of these

Show Answer

Answer:

Correct Answer: A

Solution:

  • The primary key of a relation-al table uniquely identifies each record or row in the table. For a table. It enables each record to be unique without ambiguity that is. it doesn’t allow duplicate’s, eg, In a table CUSTOMERS, ii is difficult to differentiate each on his name. Since homonyms may ex its. Therefore, it creates a field Code Client where each code is unique in designating it as primary key to ensure that every client is different.