Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT
AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A
COLUMN ?
INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN.
WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE
ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS
NULL VALUES.
- 3 Answers
- 7044 Views
- I also Faced
- E-Mail Answers
Answer Posted / adil khan
1.you can assign UK + NN TO A COLUMN behave like PRIMARY KEY(PK)
but (UK + NN) can not make any relation with any other table.
where as PRIMARY KEY(PK) can make relation with others tables.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the differences between date and timestamp in oracle?
How can we view last record added to a table?
Explain the use of indexes option in imp command.
what is IDE,DMV in sql server?
What is the scope of a local variable?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to create an oracle database manually?
What is a read only transaction in oracle?
What are the uses of synonyms?
When system tablespace is created?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
what is meant by magic query
What is different types of joins?
What is the data pump import utility?
What is recycle bin in Oracle?
