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
- 6970 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
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is catalog in Oracle?
How to Truncate Table in Oracle
Give syntax for SQL and ORACLE joins.
How to select some rows from a table in oracle?
What are the different types of synonyms?
Why use resource manager in Oracle?
How do I start tns listener?
Explain the use of indexes option in exp command.
How many types of cluster table in Oracle?
Explain about functional dependency and its relation with table design?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Why does Oracle not permit the use of PCTUSED with indexes?
What is ordinary table in oracle?
What is meant by an index?
