Interested to Buy Any Domain ? << Click Here >> for more details...
What is a candidate key?
- 7 Answers
- 16101 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 |
What are the out put files that the informatica server creates during the session running?
What are the transformations that are not supported in mapplet?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What all join we can perform in LOOKUP transformation?
What is parallel processing in informatica?
How union transformation is used?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
what happens if you try to create a shortcut to a non- shared folder?
what is normalizer transformation?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
Explain grouped cross tab?
how can run the wf through pmcmd commend? write script?
Teradata 
