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 are different types of raid levels?

0 Answers  

What is sql server 2000 work load governor?

0 Answers  

How to name query output columns in ms sql server?

0 Answers  

what is advantages in sql 2005 over sql 2000?

4 Answers  

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,




An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

Explain what are various ways to enhance the ssrs report?

0 Answers  

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

How to defragment table indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories