Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144508 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
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
explain detail about ftp in datastage?
What is data modeling with example?
Explain what a database is?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
In which table collections errors are stored.
Explain about the database management systems.
Why does this query return 0?
What is a database development?
How long can an error message be in raiseerror function?
Explain about a primary key?
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?
Explain about the hierarchical model of the database?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain about network model?
