what is difference between primary key and unique key
?

Answers were Sorted based on User's Feedback



what is difference between primary key and unique key ?..

Answer / chandonline

Basic difference between primary key and unique is that primary key is used to define a table in other tables for preventing data from anomalies,and unique key is used in a table to apply unifications among different values or columns of a tables and only in that table obviously.Their is no usage of unique key outward a table but primary key is often used to make relations between other tables.

Is This Answer Correct ?    3 Yes 0 No

what is difference between primary key and unique key ?..

Answer / ashish tyagi

The basic difference between primary key and unique key is that unique key allows null value but primary key did not allow null value.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB Development Interview Questions

Explain about post-relational databases?

1 Answers  


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1 Answers  


how will I find the duplicate rows count from employees tablein oracle.

2 Answers  


How to read and create .LDC data files which are used by linguatic dictionary.

1 Answers  


What are the main phases of database development?

1 Answers  


can you give me the syntax of named procedure??

2 Answers  


Explain about the database management systems.

1 Answers  


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

1 Answers   TCS,


How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,


Which four data types cannot be used as a return type from a user-defined function?

1 Answers  


Write the fastest query to find out how many rows exist in a table?

1 Answers  


How long can an error message be in raiseerror function?

1 Answers  


Categories