What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
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
State any two functions of oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
what is the scripts in data base?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is the difference between translate and replace?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to use select statement to count the number of rows in oracle?
How to concatenate two text values in oracle?
How to assign data of the deleted row to variables?
How do I spool to a csv formatted file using sqlplus?
How to work with data objects interactively?
What is the difference between 10g OEM and 11g OEM?
How to create a table index?
Why do we use bulk collect in oracle?
Difference between the “verify” and “feedback” command?