what is difference between candidate key and alternate key
Answer Posted / 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 |
Post New Answer View All Answers
What is Landscape in Sap BW?
my first question in huawei was ....1)Tell me about your self 2) oops concept 3)logic gates 4)ram and rom ,what is cache memory nd where it is located 5)diffrence between file system and data base 6) procedure of operating system 7)what is c# 8)high level language and machine language 9) and from mobile networkin !!!! hope thz will help you
how to increase the chiller effiency?
why c is called middle level langauge?
Tell me about a time when you had too many things to do and you were required to prioritize your tasks
What is the dewpoint of atmoshperic Air?
Given a number (N), program to check whether its binary form has periodic or not
when does the official confirmation or the offer letter for the 2012 selected candidates of HUAWEI will come??
1) There is a circular pizza with negligible thickness that is cut into 'x' pieces by 4 straight line cuts. What is the maximum and minimum value of 'x' respectively 2)A ship leaves on a long voyage. When it is 18 miles from the shore, a seaplane, whose speed is 10 times that of the ship is sent to deliver mail. How far from the shore does the seaplane catch upon with the ship? 3) If the distance traveled (s) in time (t) by a particle is given by the formula s = 1+ 2t+3t2+4t3, then what is the distance traveled in the 4th second of its motion? 4)3 men finish painting a wall in 8 days. Four boys do the same job in 7 days. In how many days will 2 men and 2 boys working together paint two such walls of the same size?
is the meter head is same as back pressure?
compare the conditional operator with if-else-if statement.
how to cable size by Amp with example
good morning! can u briefly explain the concept of syllolism and wat it mean?
Please send the details and fee for Intools training course..I would like to do the course in second week of jUNE 2010.
How does C pass variables to a function ?