1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
THAN U.

Question Posted / neha_chaudhary005


WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U...

Answer / sakthi

Primary key:
It is an unique identifier, it wont allow null value, in a
table there will be only one column as primary key.

Composite key:

It same as Primary key but combination of more that one
column.

Is This Answer Correct ?    14 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is the difference between function and stored procedure in sql server?

0 Answers  

Do you know what is blocking?

0 Answers  

Benefits of Stored Procedures?

0 Answers   Wipro,

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

What do you mean by table and field in sql?

0 Answers  




How do you delete duplicate rows in sql server?

0 Answers  

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

Can two tables share the same primary key?

0 Answers  

How to search for a string in all stored procedure in sql server?

0 Answers  

Why use update_statistics command in sql server?

0 Answers  

What is coalesce in sql server?

0 Answers  

What is policy based management (pbm)? : sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories