Question
Differentiate between Candidate Key and Alternate Key in context of RDBMS.
✓
Answer
Candidate Key: It is the one that is capable of becoming primary key i.e.,a column or set of columns that identifies a row uniquely in the relation.
Alternate Key: A candidate key that is not selected as a primary key is called an Alternate Key.
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 using pandas to do the following task
(a) To create the, Data Frame with columns Name, Occupation, Date of join, Age. The datafrme should contain only 2 rows.
(b) Add the index Emp001 and Emp002.
(c) Print the data
(d) Add a new row [Emp003]
Write a function readall() the record from the binary file “employee” and display all the records.
A school with 20 stand -alone computers is considering to network them together and adding a server. State two advantages of doing this.
Write the function definition for the following:
(a) A function ADD() accepts two parameters.
(b) A function ADD() accepts two parameters and returns a single value.
(c) A function Vote_Casting() will accepts age and citizen as parameter returns Boolean value.
(d) A function Show () accepts no parameters and returns nothing.
Rewrite the following code in Python after removing all syntax error(s). Underline each correction done in the code.
How to get the items of series A not present in series B?
Write script to input two integers and find their LCM.
Differentiate between packet switching over message switching?
Categorise the following under Client Side and Server Side script category:
(i) VB Script
(ii) ASP
(iii) JSP
(iv) JavaScript
What is the difference between Circuit Switching and Packet Switching Technique?