What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?

Answer Posted / naren

When ever you create a primary key constraint on perticular
column in a table it creates clustered index by default,
it cannot allow null values and a table having only one
primary key constraint. But in the case of Unique Key
constraint, it allow only one null value, it creates non-
clustered index by default and a table having multiple
unique key constraints.


Regards
Naren Krishna

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

781


State and explain about oracle instance?

779


What is a nested table?

850


What is oracle update statement with inner join ?

819


Explain overloading. Can functions be overloaded?

806


How to invoke the data pump export utility?

830


What is oracle rowcount?

861


How to invoke the data pump import utility?

864


How to create an initialization parameter file?

774


How do we represent comments in oracle?

857


What are a query and state the different types of queries and their uses?

774


What is the quickest way to export a table to a flat file?

787


What language does oracle use?

876


What is where clause in oracle?

793


How do we create privileges in oracle?

832