Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145732 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / pratik bachchuwar
candidate key: it is the no of uniquely identified column
(or attribute) in a table.
alternate key: it is simply defined as the (no of candidate
key) - (no of primary key in a table).
composite key: it is the group of primary or uniquely
identified key which again unique in other table.
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
What is the physical representation for a many-to-many relationship?
What are the main phases of database development?
What are the three types of database design?
How is data stored in dbms?
What is dbms explain in brief?
How you can make a parameterized view?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
I have a few records all are same structures data, I want to store data in multiple targets how
Write the fastest query to find out how many rows exist in a table?
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?
How can you log an error to the server event log from a stored procedure?
Write short notes on manual refreshes.
What are data modelling techniques?
How to replace not in with not exist?
How long can an error message be in raiseerror function?
