Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
- 3 Answers
- 7324 Views
- I also Faced
- E-Mail Answers
Answer Posted / naren
When ever you create a primary key constraint on perticular
column in a table it creates clustered index by default,
it cannot allow null values and a table having only one
primary key constraint. But in the case of Unique Key
constraint, it allow only one null value, it creates non-
clustered index by default and a table having multiple
unique key constraints.
Regards
Naren Krishna
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How to set a transaction to be read only in oracle?
What is a nested table and how is it different from a normal table?
What happens to the data files if a tablespace is dropped?
Explain about your project and its relation to the current job position you are applying to?
What is the difference between count (*), count (expression), count (distinct expression)?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to call a stored function in oracle?
How different is ms access and oracle?
Why does oracle 9i treat an empty string as null?
How do I uninstall oracle 11g?
What is parameterized cursor in oracle?
How to connect to the server with user account: sys?
What is flashback in Oracle?
Explain the difference between replace() and translate() functions in oracle?
How to convert numbers to characters in oracle?
