Difference between primary key and unique key ?
- 77 Answers
- 191032 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 / nithin
1. There can be more than one unique key in a row or table
but there can be only one primary key in a row or table.
2. Primary key does not accept NULL values but Unique key
accepts even NULL values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to drop a tablespace?
Explain the features of oracle?
How to pass parameters to procedures?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is partitioned table in Oracle?
What is varray?
What is the usage of analyze command in oracle?
How to install oracle odbc drivers?
How to select some columns from a table in oracle?
How to create a new view in oracle?
How to compare dates in oracle sql?
How to delete an existing row from a table in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Does oracle database need java?
