CBSE Class 12 Computer Science Question 65 of 78

Relational Databases — Question 7

Back to all questions
7
Question

Question 7

Which of the following attributes cannot be considered as a choice for primary key ?

  1. Id
  2. License number
  3. Dept_id
  4. Street
Answer

Street

Reason — Attributes "Id," "License number," and "Dept_id" are unique identifiers and can be suitable choices for a primary key. However, "Street" might not be unique for each tuple, as multiple tuples could have the same street value, making it unsuitable for a primary key.