Difference between primary key and unique key ?
Answer Posted / ark chowdary
7. Primary Key doesnt allow the Null Values. where as in
Unique accept the Null values.
One table may have more than one Unique Key Constraint.
But it sholud have only one Primary Key Constraint column.
| Is This Answer Correct ? | 77 Yes | 47 No |
Post New Answer View All Answers
What is oracle server autotrace in oracle?
How will you identify oracle database software release?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Write a trigger example in oracle?
In which language oracle has been developed?
What are the differences between primary key and unique key?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is oracle analytical function?
Explain the types of exception?
What is meant by recursive hints in oracle?
Difference between varchar and varchar2 data types?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to count duplicated values in a column in oracle?
How to list all indexes in your schema?
What is oracle and what are its different editions?