Difference between primary key and unique key ?

Answer Posted / rakesh dwivedi

1.Primary key can not have null.Instead of it unique can have null at lest single time null.
2 In a table only one primary key exist.Unique can be multiple in table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to retrieve values from data fields in record variables?

777


Explain how are indexes update?

820


What are group functions in oracle?

767


Explain the use of owner option in exp command.

763


How to write date and time interval literals in oracle?

754


1) Does oracle have any table which contain all the exceptions and it's code internally?

1507


How to use "for" statements in oracle?

762


Why we use bulk collect in oracle?

730


what is the use of system.effective.date variable in oracle?

868


What is the relation of a user account and a schema?

864


What is dynamic proxy?

755


What is oracle sid?

684


Explain the features of oracle?

792


What is oracle instant client?

750


How do I connect to oracle database?

734