PRIMARY KEY 1)TABLE CAN NOT HAVE MORE THAN ONE PRIMARY KEY. 2)PK DOES NO

Difference between primary key and unique key ?

Question Posted / mudigouda patil

77 Answers
210428 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 / mudigouda patil

PRIMARY KEY
1)TABLE CAN NOT HAVE MORE THAN ONE PRIMARY KEY.
2)PK DOES NOT ALLOW NULL VALUES.
UNIQUE KEY
1)TABLES CAN HAVE MORE THAN ONE UNIQUE KEY.
2)UNIQUE KEY ALLOWS NULL VALUES.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is index-organized table in Oracle?

1069

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2078

How to open a cursor variable?

1040

What is a subquery in oracle?

1111

What is ordinary table in oracle?

1159

What is rowid and rownum in oracle?

1011

ABOUT IDENTITY?

2062

What is a tns service name?

1009

Explain the dml?

986

List the parts of a database trigger.

1053

What is the difference between primary key and unique key and foreign key in oracle?

982

How to create a new tablespace in oracle?

987

Point the difference between translate and replace?

1094

What are the roles of dba?

1070

What are the different pseudo commands? Explain in general?

1080