primary key not allows null values, but unique key allows null values. only

Difference between primary key and unique key ?

Question Posted / praveen

77 Answers
210318 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 / praveen

primary key not allows null values, but unique key allows null values. only one primary is possible in one table, but multiple unique keys are possible in a table. Each unique key accepts only one null field. Both are used to prevent repeated entry of values.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the oracle implicit cursor?

1063

What is the difference between hot backup and cold backup in oracle?

1014

What are the various oracle database objects?

1144

How to convert character types to numeric types?

1134

What is oracle update statement with inner join ?

1060

What is the simplest tool to run commands on oracle servers?

1009

How can you merge two tables in oracle?

1001

How can we view last record added to a table?

1038

What is private procedure oracle?

1012

What is rowid and rownum in oracle?

1011

How to convert a date to char in oracle? Give one example.

1068

How to pass a cursor variable to a procedure?

1109

What is user managed backup in Oracle?

1146

What is the difference between formal parameters and actual parameters?

1089

How can I combine multiple rows into a comma-delimited list in oracle?

1062