Difference between primary key and unique key ?
- 77 Answers
- 198866 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 / niranjan dhungia
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 ? | 1017 Yes | 126 No |
Post New Answer View All Answers
How to connect to a remote server?
How to write a left outer join with the where clause in oracle?
What do database buffers contain?
How many types of synonyms in Oracle?
What is the use of oracle?
List out the types of joins.
How to write a query with an inner join in oracle?
How to retrieve data from an cursor to a record?
How to use select statement to count the number of rows in oracle?
Where do we use decode and case statements?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Explain the use of record length option in exp command.
How many categories of data types?
What is the difference between $oracle_base and $oracle_home?
How to change program global area (pga) in oracle?
