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

Point the difference between translate and replace?

857


What is logical backup in oracle?

813


How to define an anonymous procedure with variables?

795


How to display row numbers with the records?

834


How to load a large xml file?

850


How to delete a column in an existing table?

836


How to create a new tablespace in oracle?

778


How do I uninstall oracle 11g?

846


How to convert dates to characters in oracle?

805


How to create a server parameter file?

852


Can you assign multiple query result rows to a variable?

788


What are nested tables?

889


What is backup in Oracle?

800


What is meant by an index?

849


How can you merge two tables in oracle?

778