Difference between primary key and unique key ?

Answer Posted / sikander

Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a cusotmer as a supplier in ORACLE R12

1728


What is the difference between translate and replace in oracle?

657


Can we use bind variables in oracle stored procedure?

490


Differentiate between translate and replace?

633


What do you mean by a deadlock?

517






Explain the difference between a procedure and a function? What do you understand by those terms?

624


Can we save images in a database and if yes, how?

594


What is oracle database 10g express edition?

600


Can group functions be mixed with non-group selection fields?

536


11. Display the client number and name and the client number and name of the person who referred that client.

1922


How to create a new oracle data file?

560


How to create an oracle database manually?

571


How to display row numbers with the records?

588


What is null value in oracle?

638


Explain the use of grant option in exp command.

586