Define candidate key, alternate key, composite key?
Answer Posted / piyush kathayat
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 ? | 587 Yes | 62 No |
Post New Answer View All Answers
How can I detect whether a given connection is blocked?
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
Explain about relational database management systems?
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.
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Explain about relational operator join?
explain detail about ftp in datastage?
How would you design a database for an online site, which would average a million hits a day?
Who are naive users?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How to use timestamp datatypes
What are the three types of database design?
Explain about a primary key?
Write short notes on manual refreshes.
How you can make a parameterized view?