Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Define candidate key, alternate key, composite key.

Question Posted / swapna

Answers were Sorted based on User's Feedback



Define candidate key, alternate key, composite key...

Answer / unknown

If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.

Is This Answer Correct ?    18 Yes 28 No

Define candidate key, alternate key, composite key...

Answer / mustafa

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

Is This Answer Correct ?    15 Yes 30 No

Define candidate key, alternate key, composite key...

Answer / jheelum

A CANDIDATE KEY ISA PRIMERY KEY. OTHER ARE ALTERNATE KEY

Is This Answer Correct ?    26 Yes 82 No

Post New Answer

More SQL Server Interview Questions

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

What is data file in computer?

0 Answers  

What is bulkcopy in sql?

0 Answers  

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

What are subqueries in sql server? Explain its properties.

0 Answers  

What are triggers in ms sql server?

0 Answers  

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

How to execute a stored procedure in ms sql server?

0 Answers  

How to find the service pack installed? : sql server database administration

0 Answers  

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories