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
- 7089 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
How to display employee records who gets more salary than the average salary in the department?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What are the arithmetic operations?
Is there any function in oracle similar like group_concat of mysql?
How do I find my oracle client driver version?
What is the usage of merge statement?
How to use attributes of the implicit cursor in oracle?
How to delete a column in an existing table in oracle?
What is the quickest way to fetch the data from a table?
How to empty your oracle recycle bin?
if you ctreate table identity
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is blob datatype?
is there a tool to trace queries, like profiler for sql server?
What are the system predefined user roles?
