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

waht is the difference between primary key and super key?

Answer Posted / manoj jain

Primary key is subset of candidate key
primary key=not null+unique

candidate key is minimal form of super key ie. candidate key
is subset of super key

common feature:-
primary key,super key,candidate key is used to identify a
entity in relation

Is This Answer Correct ?    30 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain drop constraint oracle?

1036


What is SQL Tuning Advisor in Oracle?

1148


What is an oracle table?

970


How to delete an existing row from a table in oracle?

1052


What are the database administrators utilities available?

1009


How can we find out the duplicate values in an oracle table?

1032


How to add a new column to an existing table in oracle?

1116


Give syntax for SQL and ORACLE joins.

1077


What privilege is needed for a user to create views in oracle?

1023


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1002


What are the oracle differences between nvl and coalesce

1129


How to shutdown your 10g xe server?

1133


Is oracle an open source?

1061


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1896


How to convert a string to a date in oracle database?

1031