Difference between primary key and unique key ?

Answer Posted / pawan mishra

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

ABOUT IDENTITY?

1565


List out the difference between commit, rollback, and savepoint?

622


Can we write dml statement in function in oracle?

636


How to sort output in descending order in oracle?

580


How to assign data of the deleted row to variables?

581






Explain rename?

554


What happens to indexes if you drop a table?

701


What is columnar storage what is the advantage?

546


What happens if the update subquery returns multiple rows?

613


Which environment variables are absolutely critical in order to run the OUI?

1659


How to assign values to data fields in record variables?

584


What is analyze command used for?

580


does the query needs a hint to access a materialized view?

1468


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

614


How do I uninstall oracle client from windows?

538