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
- 5884 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
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Can we connect to ORACLE db using Windows Authentication?
Name the various constraints used in oracle?
Explain what are the advantages of views?
What language does oracle use?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is a relational database management system?
Explain the use of Merge statement in oracle 11g
What are the original export and import utilities?
What is data type in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is the simplest tool to run commands on oracle servers?
how can we store any pdf file in oracle
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
