Primary key does not allow null values whereas in UNIQUE constraint we can

Difference between primary key and unique key ?

Question Posted / himanshu porwal

Answer Posted / himanshu porwal

Primary key does not allow null values whereas in UNIQUE constraint we can have 1 null value means for that column one null value is allowed.

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How will you write a query to get a 5th rank student from a table student_report?

1812

Can you assign multiple query result rows to a variable?

926

What are the different windows events activated at runtime ?

2832

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

954

What is a initialization parameter file in oracle?

986

Is primary key indexed by default in oracle?

928

What happens to the indexes if a table is recovered?

940

Â How to use an oracle sequence generator in a mapping?

1016

Does oracle charge for java?

1005

What is a trace file and how is it created in oracle?

970

Is oracle a programming language?

934

How do I uninstall oracle 11g?

1038

How to fetch the row which has the max value for a column?

944

Explain about your project and its relation to the current job position you are applying to?

942

How to display employee records who gets more salary than the average salary in the department?

998