Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 208109 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 / omkar
In any table there can be one and only one primary key
(composite priamry key can have more than 1 column but
together conside one key only) but more than one unique
keys.
Primary key cannot accecpt null value.unique key accecpts
one or more than one null values.
primary key uniquly identifies the table but unique key is
used for uniquly identified of table as it contain one or
more than onee null.
Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use attributes of the implicit cursor in oracle?
Whether any commands are used for months calculation? If so, what are they?
What is Java Pool in Oracle?
What is an oracle wallet?
Describe the types of sub query?
How can you merge two tables in oracle?
What do you mean by a deadlock?
What is the use of file param in imp command?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to use in conditions in oracle?
What are the oracle differences between nvl and coalesce
Point the difference between translate and replace?
Explain the use of grant option in imp command.
What are the different pseudo commands? Explain in general?
What is data block in Oracle?
