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 a hierarchical database?
How can I create database in excel?
Enlist various types of interactions created by dbms?
What do you mean by checkpoints in dbms?
Explain the use of assign statement in progress database?
What is meant by system analysis?
What is a foreign key constraint?
What is the use of database management system?
Define a relation schema and a relation.
How do you create a database?
What do you mean by deadlock dbms?
How are exceptions handled in pl/sql? Give some of the internal exceptions name?
What is progress actional?
What are new features postgre 9.1?
Why its better to use files than a DBMS when there are multiple users to access the data