Difference between primary key and unique key ?

Answer Posted / chauhan rakesh botad

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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle rownum?

522


What is data block in Oracle?

620


How to best split csv strings in oracle 9i?

590


What is a table index in oracle?

634


How oracle handles dead locks?

602






How to turn on or off recycle bin for the instance?

611


How do I connect to oracle?

562


Is oracle the best database?

522


What are the types of trigger in oracle?

577


What is a lookup table in oracle?

542


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1442


How to load data from external tables to regular tables?

541


List the types of joins used in writing subqueries?

573


State some uses of redo log files?

568


What is an oracle recycle bin?

551