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 python program using recursive function to search an element in a list using Binary search technique.
Write a python program to accept a line from the user and store that in a file “story.txt”.
Write the definition of a function Reverse(X) in Python, to display the elements in reverse order such that each displayed element is the twice of the original element (element * 2) of the List X in the following manner:
Example:
If List X contains 7 integers is as follows:
| X[0] | X[1] | X[2] | X[3] | X[4] | X[5] | X[6] |
| 4 | 8 | 7 | 5 | 6 | 2 | 10 |
After executing the function, the array content should be displayed as follows:
What is the role of the computer in cybercrime?
Define ReIndexing.
Differentiate between packet switching and message switching technique in network communication.
What is pandas used for ?
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 the output of the given python program :
Differentiate between Candidate Key and Primary Key in context of RDBMS.