Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
- 3 Answers
- 7364 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
Which is faster join or subquery in oracle?
What is the data pump export utility?
What is instant client oracle?
What is the usage of merge statement?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain the use of analyse option in exp command.
How to manage transaction isolation level?
what are steps for interface? where is exchange rate defined in which table?
What is an external table?
How to insert a record into a table?
Explain the use of record length option in exp command.
How to list all indexes in your schema?
What is the difference between pre-select and pre-query?
How to run create database statement again?
