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

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

What is recompile sql server?

0 Answers  

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

Can you please explain the difference between function and stored procedure?

0 Answers  

Explain user defined functions?

0 Answers  

How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,

Explain syntax for viewing trigger?

0 Answers  

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

Do you know the policy based administration feature of sql server 2008?

0 Answers  

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories