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...

what is candidate key & super key

Answer Posted / naresh

Cnadidate Key:
A Candidate Key (CK) is a column or group of columns that
uniquely describe every row in a table. The difficult thing
with this is that there may be exceptions in almost every
case. For instance, it is possible to have two people who
share the same name and birthdate but are really two
different people.

Super Key:
a superkey is a set of composite columns forming a key that
may be used to uniquely identify a row in a table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are a collation and state the different types of collation sensitivity?

1095


20. Using a set operator, display the client number of all clients who have never placed an order.

2147


Is insert autocommit in oracle?

1019


How to use fetch statement in a loop?

973


What is the difference between a primary key & a unique key?

1041


What is the quickest way to fetch the data from a table?

1001


How to create a table interactively?

999


What do you know about normalization? Explain in detail?

881


How to define a record variable to store a table row?

1005


What is difference between cartesian join and cross join?

1018


What is the use of oracle?

983


How can we find out the current date and time in oracle?

1037


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

1986


What are the major difference between truncate and delete?

984


What is merge in oracle?

997