primary key has no null values whereas unique accepts null values and in

Difference between primary key and unique key ?

Question Posted / niraj pratap singh

77 Answers
210262 Views
Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
E-Mail Answers

Answer Posted / niraj pratap singh

primary key has no null values whereas unique accepts null
values and in a table only one primary key is declared
whereas unique key is multiple in a table.

Is This Answer Correct ?

10 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can I create users through internet explorer in oracle 10g?

1084

How to use "in out" parameter properly?

1048

Which is better Oracle or MS SQL? Why?

6386

Can we write insert statement in function in oracle?

1089

How to write text literals in oracle?

1068

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

How to check database size in Oracle?

1191

How to check the oracle tns settings?

1047

What is Segment Advisor in Oracle?

1103

How data locks are respected in oracle?

1071

Explain overloading. Can functions be overloaded?

986

What are data pump export and import modes?

1068

How to view the data files in the current database?

1098

How to get execution path reports on query statements?

987

What is BBED in Oracle?

1154