Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210274 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
How can we delete duplicate rows in a table?
Explain self joins in oracle?
How do you find current date and time in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to define a variable of a specific record type?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is a proxy class?
What is the sid in oracle?
What do you know about normalization? Explain in detail?
How to list all user accounts in oracle?
What the is the diff between local index and global index. give some example.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is bulk copy or bcp in oracle?
What is key preserved table?
What are the extensions used by oracle reports?
