Question
What are candidate keys in a table? Give a suitable example of candidate keys in a table.
✓
Answer
A table may have more than one such attribute/group of attribute that identifies a tuple uniquely, all such attribute(s) are known as Candidate Keys.
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
Differentiate between DDL &DMLcommands. Identify DDL &DML commands from the following:
(UPDATE, SELECT, ALTER, DROP)
Write a function to read the content from the "quotes.txt" and transfer the content to the file "Duplicate.txt" but while transfer all the upper case character to lower case character, lower case character to uppercase character and rest of the character as it is.
Write the python function to accept the rollno as parameter and find out whether record present in the table or not
WAP in python to create the duplicate copy of the list.
Give two examples of PAN and LAN type of networks.
Write a program using recursion function to accept the list from the user and print sum of all the elements in the list.
How to iterate over a Pandas DataFrame?
Write the python function to accept the employee number as parameter and find out whether the record is present in the table or not.
Write the function to update() to accept the values as parameter and update the record according to the passed values. Assuming that values exist in the table.
Write the output of the given program:
