Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144859 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / kumaresan chandran
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 ? | 89 Yes | 27 No |
Post New Answer View All Answers
How to generate OIDS
Explain the rollup operator?
What are data modelling techniques?
State the acid rules?
How can you log an error to the server event log from a stored procedure?
Who are naive users?
What is the physical representation for a many-to-many relationship?
Explain the process of the user request and data generating?
What is DB Development software?
Write short notes on manual refreshes.
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
In which table collections errors are stored.
How can I detect whether a given connection is blocked?
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.
Explain about the storage and physical database design?
