--->We Define only one PK per table but it should have one or more UK.

Difference between primary key and unique key ?

Question Posted / saga

Answer Posted / saga

--->We Define only one PK per table but it should have one
or more UK.
--->PK does not contain null but UK contains null.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How would you begin to troubleshoot an ORA-3113 error?

2049

What is coalesce function?

1034

How to drop a tablespace?

1012

What is the purpose of save points in oracle database?

1041

Explain the features of oracle?

1001

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2147

How to delete all rows a table in oracle?

1030

How to define a sub function?

1101

What is an external table?

978

Explain constraining triggers.

1055

How different is ms access and oracle?

999

What are the differences between char and nchar in oracle?

1042

What is the difference between substr & instr functions?

1165

What is meant by a deadlock situation?

1071

How to define an anonymous block?

1101