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

How to export data with a field delimiter?

798


List the types of joins used in writing subqueries?

767


How to login to the server without an instance?

829


When do you get a .pll extension in oracle?

922


What is key preserved table?

750


How a tablespace is related to data files?

825


How to check database size in Oracle?

863


How to join two tables in a single query using oracle?

775


What is a cognitive schema?

711


What is merge in oracle?

801


What is the relation of a user account and a schema in oracle?

854


How would you begin to troubleshoot an ORA-3113 error?

1855


Write a trigger example in oracle?

807


Difference between inner join vs where ?

800


what is a Nested Loop join?

1817