Difference between primary key and unique key ?

Answer Posted / satya

Primery Key = (Unique key - NULL values)

One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.

Any comment? please shoot a mail.

Is This Answer Correct ?    329 Yes 90 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between substr and instr?

703


what is a Nested Loop join?

1781


Why use resource manager in Oracle?

861


How to pass a parameter to a cursor in oracle?

834


How to get last row id?

732


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

744


Will you be able to store pictures in the database?

859


How to get maxsal , minsal, ename department wise in single query

1291


What is BBED in Oracle?

894


Explain the use of owner option in exp command.

755


What is a cognitive schema?

686


Can you have more than one content canvas view attached with a window ?

2027


What is hot backup and logical backup?

801


How many types of auditing in Oracle?

784


How to create a stored program unit?

788