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

How to drop an existing user defined function in ms sql server?

0 Answers  

What are group functions in query statements in ms sql server?

0 Answers  

what is lazy writer?

1 Answers   Wipro,

What are various ways to enhance the ssrs report?

0 Answers  

How to move database physical files in ms sql server?

0 Answers  

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

What are differences in between sql server 2012 and sql server 2016?

0 Answers  

How to get nth highest salary from employee table.

0 Answers  

List some case manipulation functions in sql?

0 Answers  

Define the term DML, DDL and DTL?

1 Answers  

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

difference between truncate, delete aur drop?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories