Difference between primary key and unique key ?

Answer Posted / niraj pratap singh

primary key has no null values whereas unique accepts null
values and in a table only one primary key is declared
whereas unique key is multiple in a table.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can group functions be used in the order by clause in oracle?

752


What are dml statements in oracle?

788


Is oracle an open source?

788


query optmization techniques and quwry analyser+projects+ppts

2134


What is recycle bin in Oracle?

882


How to create a new tablespace in oracle?

725


What is the difference between "as" and "is" in an oracle stored procedure?

739


Where is the export dump file located?

768


What is integrity and what is constraint??Explain with example

1944


Is insert autocommit in oracle?

779


How to resolve the ORA-39133 error in Oracle?

786


What is background process in Oracle?

820


What is sequence?

813


What is flashback in Oracle?

735


What do database buffers contain?

739