Primary Key 1. Not Null 2. One primary key can be defined at on table

Difference between primary key and unique key ?

Question Posted / satendra dixit

77 Answers
210265 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 / satendra dixit

Primary Key
1. Not Null
2. One primary key can be defined at on table

Unique Key
1. May be Null
2. one or more then 1, can be implemented

Is This Answer Correct ?

22 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I connect to oracle database?

1119

How do I find my oracle client driver version?

1040

What is recovery manager in Oracle?

1056

What is the difference between pre-select and pre-query?

1219

How to delete multiple rows from a table in oracle?

1060

How to use subqueries with the exists operator in oracle?

1027

How to invoke the data pump export utility?

1187

How to call a stored function with parameters?

1045

How to create a server parameter file?

1135

How to get execution statistics reports on query statements?

1094

How to turn on or off recycle bin for the session?

1109

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

1084

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2273

What are privileges and grants?

1067

Difference between pre-select and pre-query

1108