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



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

how can a database be repaired? : Sql server administration

0 Answers  


What does the on delete cascade option do?

0 Answers  


What are synonyms?

0 Answers  


What is a trigger?

7 Answers  


explain the type of contraints

3 Answers  






How to integrate the ssrs reports in application?

0 Answers  


Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,


Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  


Can we delete data from a view?

0 Answers  


Can you explain what are various ways to enhance the ssrs report?

0 Answers  


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  


How can I create a report based on a query? : sql server management studio

0 Answers  


Categories