Difference between primary key and unique key ?

Answer Posted / niranjan dhungia

Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).

Is This Answer Correct ?    1017 Yes 126 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1844


State some uses of redo log files?

788


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4330


What is the difference between translate and replace in oracle?

938


How to insert a new row into a table in oracle?

879


What is oracle used for?

786


How do I limit the number of rows returned by an oracle query after ordering?

919


How to assign a tablespace to a users in oracle?

814


What are the types of trigger in oracle?

782


What is transaction control statement and how many types of transaction control statement in Oracle?

848


What is user managed backup in Oracle?

861


Explain the use of grant option in exp command.

799


What is max rowid in oracle?

806


What is system tablespace?

872


what is port in oracle? how is it related to database application.

1732