Difference between primary key and unique key ?

Answer Posted / pankaj kumar tiwari

primary key create index it means its value inserted in
sequence but in unique, we insert data in any order

Is This Answer Correct ?    15 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write text literals in oracle?

817


What is the difference between sharding and partitioning?

719


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1837


What are the different windows events activated at runtime ?

2594


What is the recommended interval at which to run statspack snapshots, and why?

2640


List out the types of joins.

832


Can you assign multiple query result rows to a variable?

739


How to create a new view in oracle?

821


How to install oracle database 10g xe?

761


How many file formats are supported to export data?

862


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1984


Explain the difference between replace() and translate() functions in oracle?

787


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2027


How to load data through external tables?

840


How to delete a user account in oracle?

736