Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 71 of 79

MySQL SQL Revision Tour — Question 14

Back to all questions
14
Question

Question 14

Which of the following types of table constraints will prevent the entry of duplicate rows ?

  1. Unique
  2. Distinct
  3. Primary Key
  4. NULL
Answer

Primary Key

Reason — A primary key is a set of one or more attributes or fields that uniquely identifies a tuple or row in a table. Therefore, it ensures that each row in the table is unique and prevents the entry of duplicate rows.