Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210077 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 / ela tiku
1. Primary key does not allow Nill value whereas Unique key
allows Null values.
2. There can more than one Unique key for a table however
there is only one primary key for ant tanle.
2. Whenever a primary key is assigned by default a
Clustered Index is created whereas When a Unique key is
created a Non Index clustered index is created...
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is the parameter mode that can be passed to a procedure?
Can you have more than one content canvas view attached with a window ?
What happens if the update subquery returns multiple rows?
What is a cognitive schema?
How to create an oracle testing table?
What is bulk copy or bcp in oracle?
What is a trigger and what are its types?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How do we represent comments in oracle?
How to save query output to a local file?
What is a read write transaction in oracle?
How to write a left outer join with the where clause in oracle?
What is a database table in oracle?
Whether any commands are used for months calculation? If so, what are they?
How to upsert (update or insert into a table)?
