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
208258 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 the database name in oracle?

986

How to define a data field as not null?

1073

How to sort the query output in oracle?

978

What is the oracle implicit cursor?

1017

Does oracle partitioning improve performance?

957

Explain the use of consistent option in exp command.

994

How to execute the package in oracle?

1051

How to delete multiple rows from a table in oracle?

1021

What are the differences between number and binary_float in oracle?

1069

Explain cascading triggers.

1027

How different is ms access and oracle?

996

How to add a new column to an existing table in oracle?

1097

What is the relation of a user account and a schema in oracle?

1021

What is an anonymous block?

1178

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3007