Define candidate key, alternate key, composite key?
Answer Posted / palanivel
primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.
Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.
Composite key:- A primary key that consistsof two or more
attributes is known as composite key
candidate key:- is a column in a table which has the
ability to become a primary key.
Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to generate OIDS
How is data stored in dbms?
Can an extended stored procedure be called from inside a user-defined function?
What is dbms and its application?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
State the acid rules?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What is a database development?
Explain about post-relational databases?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Explain the rollup operator?
How to read and create .LDC data files which are used by linguatic dictionary.
Who are end users in dbms?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Write short notes on manual refreshes.