Difference between primary key and unique key ?
Answer Posted / vitthal parkar
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
Is This Answer Correct ? | 35 Yes | 58 No |
Post New Answer View All Answers
What are the advantages of oracle 12c?
What is a schema in oracle?
What are the attributes that are found in a cursor?
What is the dynamic sql in oracle?
Is oracle an open source?
How to create a temporary table in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the implicit cursor in oracle?
What happens if the imported table already exists?
what are bitmap indexes? How does they work?
What are the different types of synonyms?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Does oracle partitioning improve performance?
Why do we need oracle client?
What is Undo Management Advisor in Oracle?