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

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1284


How to count groups returned with the group by clause in oracle?

586


How to connect ms access to oracle servers?

554


Explain the difference between sql and oracle?

588


What is the difference between online and offline backups?

567






Explain an exception and its types?

617


What is oracle thin client?

544


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1943


How to define a data field as not null?

638


How to assign a table row to a record variable?

586


What are the restrictions on external table columns?

555


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1477


What is redo log?

632


How to speed up webrick?

606


What is raw datatype?

597