Difference between primary key and unique key ?

Answer Posted / sonali.s

column having primary key constraint should not contain
null values.

column having unique key constraint can contain null values.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert a string to a date in oracle database?

544


what is reindexing?

1179


What are the different types of failures that occur in Oracle database?

605


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

570


What is a trigger oracle?

565






definition of cluster and non-clustered index?

2479


How to execute the package in oracle?

572


20. Using a set operator, display the client number of all clients who have never placed an order.

1801


How to update values in a table in oracle?

579


What are the numeric comparison operations?

633


Explain an extent?

661


How to start a new transaction in oracle?

593


Can we store images in oracle database?

554


What is the best way to do multi-row insert in oracle?

563


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1658