Question 3 - MCQ questions - Chapter 8 - Database Concepts

Last updated at Dec. 14, 2024 by

____________ refers to the attribute that can uniquely identify tuples within the relation.

(A) Foreign key

(B) Consolidate key

(C) Alternate Key

(D) Primary key

 

Answer:

Checking the options

  • (A) Foreign key -  It is used to represent the relationship between two tables/relations.
  • (B) Consolidate key  - It is not a valid key in the relational database.
  • (C) Alternate Key - It is a candidate key which has not been selected to be the primary key.
  • (D) Primary key - It is used to uniquely identify the tuples in a relation.

From the above explanation, we understand that the primary key is the attribute which can uniquely identify tuples within a relation.

So, the correct answer is (D)

Go Ad-free

Transcript

____________ refers to the attribute that can uniquely identify tuples within the relation. (A) Foreign key (B) Consolidate key (C) Alternate Key (D) Primary key Checking the options (A) Foreign key - It is used to represent the relationship between two tables/relations. (B) Consolidate key - It is not a valid key in the relational database. (C) Alternate Key - It is a candidate key which has not been selected to be the primary key. (D) Primary key - It is used to uniquely identify the tuples in a relation. From the above explanation, we understand that the primary key is the attribute which can uniquely identify tuples within a relation. So, the correct answer is (D)

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo