Difference between primary key and unique key ?

Answer Posted / jason james john

unique key is a key that uniquely defines the characteristics of each row whereas primary key consists of characteristics that cannot collectively be duplicated by any other row.primary key will not allow null values whereas unique key will allow nulls.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between formal parameters and actual parameters?

547


What is the difference between postgresql and oracle?

508


What is a read write transaction in oracle?

606


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

570


How to select some columns from a table in oracle?

553






What language does oracle use?

599


How to assign values to variables?

580


What is concurrency in oracle?

547


What are the logical operations?

677


Why is oracle database so popular?

566


How to connect to oracle using service name instead of sid?

553


what is the scripts in data base?

1605


Please explain oracle data types with examples?

590


please explain.. DB architecture ...

1567


How to list all indexes in your schema?

584