Answer / rahul khanke

primary key : primary key dose not except null value
unique key : it accept null values.. if it set to not null
then it as good as primary key.

Answer / hema

Unique :: it does not allow duplicate values but allows
null values.
Primary:: Primary does not allow duplicate values as wel as
it dosnt allow null values.

unique+not null==Primary key...

Answer / dhanashree

Unique Key can be NULL
But
Primary Key can not be NULL

Answer / madhu

unique key:
1.unique key will accept more than one null value.
2.whenever u created a unique key, then internally one non-clustered index will be created(one table can have more than one Non-clustered index).
3.one table can have more than one unique key.
Primary key:
1.One table should have one primary key only.
2.primary key will not accept null values.
3.whenever u created a primary key then internally one clustered index will be created(one table can have only one clustered index).

Answer / gourvendra singh

Unique : One or more unique key in a table,
allow only one null in the field.

Primary :Only one primary key in a table and u cannot
insert null into it.

Answer / nagurthilak

Through Unique key we cant establish the relation between to
two tables but from primary key it is possible

Answer / l..l.n.reddy

PRIMARY KEY:- only one primary key in a table.

UNIQUE KEY:- One or more unique key in a table.

Can you load data into multiple tables at once? : aql loader

0 Answers  

what is try_catch block in procedure

0 Answers  

Talk about views

10 Answers   Polaris,

What is the difference between clustered and non-clustered indexes?

0 Answers  

What is java sql package?

0 Answers  

What are the various levels of constraints?

0 Answers  

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

Which sql statement is used to return only different values?

0 Answers  

Why we use joins in sql?

0 Answers  

What is percent sign in sql?

0 Answers  

What are the sql commands?

0 Answers  

What is pl sql variable?

0 Answers