Bright Tutorials Bright Tutorials
CBSE Class 11 Informatics Practices Question 6 of 85

Database Concepts — Question 6

Back to all questions
6
Question

Question 6

Assertion (A): Each table must have one primary key.

Reasoning (R): Primary key is a set of one or more attributes that uniquely identifies a tuple in a relation.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

Both A and R are true and R is the correct explanation of A.

Explanation
In a database, each table can have only one primary key, which is unique and non-redundant in nature. The primary key is a set of one or more attributes or fields that uniquely identify a tuple or row in a relation.