Is primary key = unique key,not null?
If yes,please explain
IF No,please explain

Answer Posted / neeraj

No, Both are different, If we use the combination "unique+not null" the referential integrity is not maintained and that is not the case with primary key.
I think you got the difference.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State any two functions of oracle?

632


What is a connect identifier?

536


How do you bind variables in oracle?

542


Explain what are the advantages of views?

605


Is the After report trigger fired if the report execution fails ?

2402






What is columnar storage what is the advantage?

542


What do you mean by a database transaction & what all tcl statements are available in oracle?

549


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1739


What is tns service name?

616


does the query needs a hint to access a materialized view?

1462


How to check the oracle tns settings?

571


What is merge statement used for?

563


Why oracle is used?

578


What is the simplest tool to run commands on oracle servers?

511


What is varray?

587