Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146530 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / sonal singhal
Candidate keys-> A candidate key is a combination of
attributes that can be uniquely used to identify a database
record without any extraneous data. Each table may have one
or more candidate keys. One of these candidate keys is
selected as the table primary key.
Alternate keys-> Alternate Key or Unique Key is similar to
PK ,except it accepts null Values .So that the records can
still be entered submitting null values to this attribute.
Composite keys-> compound key (also called a composite key
or concatenated key) is a key that consists of 2 or more
attributes.
A composite Key can be either Primay or Unique
Key.More then One Key columns are said to be composite keys
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What are the 18 schemas?
What is data modeling with example?
Write short notes on manual refreshes.
Which data type cannot be used as a parameter in a udf?
Can an extended stored procedure be called from inside a user-defined function?
Explain the role of indexing in databases?
Explain about xml databases?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
How to use online Backups?
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
How can you fix a poorly performing query?
I have a few records all are same structures data, I want to store data in multiple targets how
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
How to replace not in with not exist?
