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 difference between candidate key and alternate key

Answers were Sorted based on User's Feedback



what is difference between candidate key and alternate key..

Answer / umer bhat

Any attribute (or set of attributes) that uniquely
identifies a row in a table is a candidate key for primary
key. Such an attribute is called a candidate key. One of
the candidate keys is chosen to be the primary key, based
on the familarity and greater usage. Any attribute that is
a candidate key for the primary key but is not the primary
key is called the Alternate key. When the key uniquely
identifies the row of the table is made than one attribute,
it is called a Composite key.

Is This Answer Correct ?    15 Yes 8 No

what is difference between candidate key and alternate key..

Answer / burhan mughal

All candidate keys which are not chosen as "primary key"
are Alternate keys. The key which uniquely identify the
rows of the table and which is made up of more than one
attribute is called Composite key. Generally a candidate
key becomes the primary key of the table. If the table has
more than one candidate key, one of them will become the
primary key, and the rest are called alternate keys.

Is This Answer Correct ?    11 Yes 8 No

what is difference between candidate key and alternate key..

Answer / bidut karki

Candidate key is a key that works as to uniquely define a record by combination of all attribute inside a table.
However, A candidate key that is not a primary key is called an Alternate key.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Engineering AllOther Interview Questions

sir i m reject two time in u.s in spring intake now im taking a date of 1july-2010 in fall intake &im competed my bachlor degree(chem) in jun-2009 so what answer i give to visa officer ask me a what r u doing last 1-year bcoz i have no work expirience

0 Answers  


how convert the spiral model to prototype model ?

0 Answers  


How to work Air cooled and water cooled chiller?

0 Answers  


Given a number (N), program to check whether its binary form has periodic or not

0 Answers  


Prove that in a self-complementing code the sum of the weights must be 9?

7 Answers   IIIT, Mind Tree, TCS,


it consists of 4 panel 2 for computers and 2 for ECE. Here are the questions asked in c-dot for c.s 1. c language. sorting=merge and quick, pointers i.e abut link list insertion deletion ,interpreter vs compiler, preprocessor, macros, what is int, array ,linklist , pointer basic queston were asked. networking = DHCP,ARQ,RARQ,DIFF BETWEEN UDP AND TCP, IF U HAVE MADE ANY LAN CHAT AUR GTALK APPLICATION THEN WHAT IS IMPLEMENTED IN IT I MEAN TCP AUR UDP? DNS, AND THINGS RELATED TO UR PROJECT AUR TRAIING. OPERATING SYSTEM= DEFINATION, FUNCTION , BLOCKED PROCESS, AND ALSO PLZZ GO THROUGH DIFF SCHEDULING ALGO, VIRTUAL MEMORY. JAVA= IF U HAVE DONE COURSE IN JAVA THEN JUSTIFY HOW JAVA IS BETTER DEN C++. PLEASE DO COMPARE PROPERLY BCZ MANY FEATURE OF JAVA ARE ALSO DER IN C++ SO WHAT IS THE BASIC DIFF BETWEEN THEM... DATABASE= SIMPLE PL/SQL QUERRY SYTENX AND INNER JOIN OUTER JOIN SO JUST HAVE A LOOK THAT SIMPLY WHAT ARE THE SYNTAX.... FIRST YOU WULD BE ASKED TO INTRODUCE YOUSELF . SECOND WOULD BE ASKED ABUT YOUR FAV SUBJECT. SO THATS IT ALLL THE BEST............. AND GUYS EVERY ONE SHULD POST THE LIST OF QUESTION ASKED IN ANY COMPANY IN THE FORUM WHERE IN SUBJECT THE COMPANY NAME SHULD BE MENTIONED

0 Answers  


How to defaultly populate charges in Clear transactions window for Cash Management?

0 Answers  


how many protocols are available and what are they?

0 Answers   IIHT,


What are the input documents to 1.Functional testing,2.System testing and 3.Integration testing. Whether there will be separate test cases for regression testing or functional testing?

0 Answers  


hi i am an CSE engg student and i cleared the PE exam of BEL 2012 both 24/07/012 and 01/08/2012 , so please if someone can help me with PE Interview question or subject or topics which i should cover that help me clear both Interview.PLZ help. my mail id is rjjkumar99@gmail.com

0 Answers   BEL,


Email bombing is

1 Answers   NIC,


Write a function that responds to a click anywhere on the page by displaying an alert dialog. Display the event name if the user held Shift during the mouse click. Display the element name that triggered the event if the user held Ctrl during the mouse click. (Answer in Java Language)

2 Answers   Infosys,


Categories
  • Civil Engineering Interview Questions Civil Engineering (5086)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4456)
  • Electrical Engineering Interview Questions Electrical Engineering (16639)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)