Interested to Buy Any Domain ? << Click Here >> for more details...
What is a candidate key?
- 7 Answers
- 15607 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data(unique). Each table may have one or more
candidate keys. One of these candidate keys is selected as
the table primary key else are called Alternate Key.
| Is This Answer Correct ? | 19 Yes | 0 No |
Answer / subramanyam
A key that uniquely identifies rows in a table. Any of the
identified candidate keys can be used as the table's
primary key. Any of the candidate keys that is not part of
the primary key is called an alternate key. One can
describe a Candidate Key as a Super Key that contains only
the minimum number of columns necessary to determine
uniqueness.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / lavanya
A candidate key is one that can identify each row of a
table uniquely. 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 ? | 5 Yes | 1 No |
Answer / surendra
A candidate key is one that can identify each row of a
table uniquely. 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.
A key formed by combining at least two or more columns is
called composite key.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sivakumar
A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data(unique).One of these candidate keys is selected as
the table primary key else are called Alternate Key. Each table may have one or more
candidate keys. One of these candidate keys is selected as
the table primary key else are called Alternate Key.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to retrieve last two days updated records?
Mention a few design and development best practices for informatica?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What is main use of mapplet?
how to load duplicate row in a target
what is target load plan
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is meant by lookup transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Enlist the differences between database and data warehouse.
What are the ETL tools available in DWH?
Teradata 
