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

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1822


What are the key features of dbms?

794


What are the types of database model?

834


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

2304


Explain about xml databases?

864


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

820


What are data modelling techniques?

750


Write short notes on manual refreshes.

2518


How to use timestamp datatypes

1803


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

1907


fact table and dimension table containg one to many relationship or many to one relastionship

2284


You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

746


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

795


Explain what a database is?

831


How to combine two function together?

1885