Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 208341 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / rubiya george
Primary Key Vs Unique key
1.Each table having 1. contain many UNIQUE KEYS.
only one PRIMARY KEY.
2.Primary key not accepts 2.Unique Key accepts null
null values values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a user and a schema in oracle?
What is Undo Management Advisor in Oracle?
Explain the use of ignore option in imp command.
What are the advantages of oracle?
What privilege is needed for a user to create tables in oracle?
How to work with data objects interactively?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What happens if you use a wrong connect identifier?
How would you change old and new values in an insert, delete and update triggers?
How to create id with auto_increment on oracle?
Explain an index segment?
Can you drop an index associated with a unique or primary key constraint?
What is analyze command used for?
How to use "if" statements on multiple conditions?
