Interested to Buy Any Domain ? << Click Here >> for more details...
If we declare constraints Unique and Not null on a single
column then it will act as a Primary key, so what is the use
of primary key??
- 3 Answers
- 7510 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha sinha
1) Primary key creates clustered index and unique key
creates non-clustered index. Performance wise clustered
index is fast so we need Primary key.
2)if we need more then one primary key in table than we can
use unique key+NOT NULL becous it behave as Primary key but
we cant define more than one column as primary key. :)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How we can update the view?
What does pl sql developer do?
what is the difference difference between procedure and packages
Is sql open source?
How do I view a sql trace file?
What does data normalization mean?
What is compiled query?
What are actual parameters and formal parameters?
Can we join two tables without common column?
What is normalisation and its types?
What is meant by user defined function?
What does sign mean sql?
What is crud stand for?
What is the location of pre_defined_functions.
What is cartesian join in sql?
