Define candidate key, alternate key, composite key?

Answer Posted / vishal sharma

hi, to all. In a interview i asked a question that

"How to apply practically candidate key in SQL SERVER ?
like for primary key we apply PRIMERY KEY keyword how to apply in SQL-SEVER ?"

Plz help me to solve this question Plzzzzzzzz

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which data type cannot be used as a parameter in a udf?

580


How can you fix a poorly performing query?

624


Explain the role of indexing in databases?

645


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1998


explain detail about ftp in datastage?

1819






What is the database development process?

692


What is an application role and explain a scenario when you would use one?

566


How can I detect whether a given connection is blocked?

588


Explain about xml databases?

626


How to replace not in with not exist?

1470


I have a few records all are same structures data, I want to store data in multiple targets how

2147


Explain about the database management systems.

572


What are the key features of dbms?

574


Explain about query and reporting.

1694


How to generate OIDS

1666