Question
Differentiate between Candidate Key and Primary Key in context of RDBMS.
✓
Answer
Candidate Key: All such attributes/columns, which can uniquely identify each row/record in a table
Primary Key: An attribute/column among the Candidate Keys which is used to uniquely identify each row/record in a table
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Write a program to Read the content of the file line by line and print without ‘n’. Assuming that file name is “multiline.txt”.
Write a Python program to plot the score of 2 players in one over on same plot with suitable legends of each line.
Write the time complexity of the above program code if it is written differently
List one similarity and one difference between List and Dictionary datatype.
To display even natural numbers from 2 to n, where n is to be input from the user. For example, if the value of n is 13, the output should be 2 4 6 8 10 12.
To input an integer and check whether it is a prime number or not.
List down all acts that comes under cybercrime.
Describe Data Operations in Pandas.
Write the output of the given python program :
Differentiate between the terms primary key and alternate key.