Each table having only one PRIMARY KEY.And my contain many UNIQUE KEYS. P

Difference between primary key and unique key ?

Question Posted / pralhad

77 Answers
212229 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 / pralhad

Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.

Is This Answer Correct ?

63 Yes

47 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is transport network substrate (tns) in oracle?

1089

How to convert dates to characters in oracle?

1086

What are the types of partitions in oracle?

1076

Why do we use coalesce function in oracle?

1163

What is oracle join syntax?

1059

Difference between varchar and varchar2 data types?

1251

What are the different types of partitions in oracle?

1027

Please explain compound trigger in oracle?

1103

Difference between open_form and call_form in oracle.

1217

Explain joins in oracle?

1088

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2265

Is java required for oracle client?

1041

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2191

How to get execution path reports on query statements?

1038

Give the various exception types.

1035