what is the difference between unique and primary key
Answer Posted / divyarao
primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is dbms with example?
What is the purpose of a model?
What's the difference between clustered and non-clustered indexes?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
What is like operator for and what are wild cards?
What database does facebook use?
Define phantom deadlock.
Explain primary key and composite key.
Mention the different types of cursor?
Which database is best for storing large data?
What are the properties of a primary key in DBMS?
How to determine who is and change the owner of database?
Explain database partitioning and its importance.
What is raid controller technology?
What is an image database?