Unique-Duplicates not allowed Nulls allowed Not null-NUlls not all

what are the advantages of primary key over unique+notnull

Question Posted / charumathi

Answer Posted / charumathi

Unique-Duplicates not allowed
Nulls allowed
Not null-NUlls not allowed
Primary key-No Duplicates
No Nulls
A Foriegn key can refer to the primary key.

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is a data manipulation language?

745

How do I run sql?

826

Is left join same as join?

729

What is the main reason behind using an index?

725

What is trigger and types?

758

What is the usage of when clause in trigger?

759

explain mysql aggregate functions. : Sql dba

724

What is clustered and nonclustered index in sql?

697

What is consistency?

886

How to read xml file in oracle pl sql?

691

what is the command line end user interface - mysql? : Sql dba

695

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1742

How subquery works in sql?

727

Explian rowid, rownum? What are the psoducolumns we have?

758

What is the difference between function and procedure in pl/sql?

748