Interested to Buy Any Domain ? << Click Here >> for more details...
When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
- 2 Answers
- 17942 Views
- Accenture, Unisoft Infotech, I also Faced
- E-Mail Answers
Answer Posted / swapna
The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.
But use it for the purpose of referential integrity will
not allow to do so.
That's what PK is so useful. You will use it for
normalization purpose.
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
How do sql triggers work?
what are the differences between char and varchar? : Sql dba
Is sql pronounced sequel or sql?
what is text? : Sql dba
Why commit is not used in triggers?
i have some prob lem to tell me about my self in interview first round ...
What are the benefits of stored procedures?
What is java sql drivermanager?
Why do we need databases?
What is schema in sql?
Why primary key is required?
What is aggregate function in sql?
What is column?
Is pl sql better than sql?
How do I find duplicates in the same column?
