Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is differance unique key and primary key.

Answers were Sorted based on User's Feedback



What is differance unique key and primary key...

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.

Is This Answer Correct ?    5 Yes 0 No

What is differance unique key and 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...

Is This Answer Correct ?    6 Yes 1 No

What is differance unique key and primary key...

Answer / dhanashree

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

Is This Answer Correct ?    6 Yes 1 No

What is differance unique key and primary key...

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).

Is This Answer Correct ?    0 Yes 0 No

What is differance unique key and primary key...

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.

Is This Answer Correct ?    1 Yes 2 No

What is differance unique key and primary key...

Answer / nagurthilak

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

Is This Answer Correct ?    3 Yes 4 No

What is differance unique key and primary key...

Answer / l..l.n.reddy

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

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

Is This Answer Correct ?    1 Yes 3 No

Post New Answer



More SQL PLSQL Interview Questions

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  


What is a sql instance vs database?

0 Answers  


what is d diff between grant,commit,rollback n savepoint

1 Answers  


How can we optimize a sql query?

0 Answers  






Can you selectively load only those records that you need? : aql loader

0 Answers  


What are all different types of collation sensitivity?

0 Answers  


is mysql query is case sensitive? : Sql dba

0 Answers  


i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  


How to execute OS(operating system) command from pl/sql?

3 Answers  


what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,


How do I create an index in word?

0 Answers  






Categories