Define candidate key, alternate key, composite key.

Answer Posted / mustafa

How do we specify an ALTERNATE KEY while creating a table?

Is This Answer Correct ?    15 Yes 30 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you edit the .rdl code associated with a linked report?

109


Do you know what are various aggregate functions that are available?

523


Does sql server use java?

514


What is BCP? When does it used in sql server 2012?

576


If no size is defined while creating the database, what size will the database have?

544






What is command parameter in ssrs?

120


How many primary keys are possible in a table?

515


What the different components of Replication and what is their use?

553


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1545


what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

526


Can you please differentiate between a primary key and a unique key?

531


What are pessimistic lock and optimistic lock?

546


How to provide values to user defined function parameters?

553


What are the 3 types of schema?

597


How many categories of data types used by sql server?

591