Define candidate key, alternate key, composite key?
Answer Posted / sanjay p sonar
Candidate key:-A candidate key is unique. We may say that
candidate key is another name of primary key. We can have
more than one candidate key. From which we have to choose
one as a primary key.
Alternate key:-The Candidate key other than primary key is
Alternate key. We can have more than one Alternate keys.
Composite key:- When we combine more than 1 column by key
then that key is called Composite key
Clustered Key:- When we combine more than 1 column to form
Primary key then it will become Cluster key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have a few records all are same structures data, I want to store data in multiple targets how
How to generate OIDS
What is the physical representation for a many-to-many relationship?
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.
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain about query and reporting.
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
In which database can extended stored procedures be added?
What are the key features of dbms?
How to combine two function together?
How can you fix a poorly performing query?
How is data stored in dbms?
How would you design a database for an online site, which would average a million hits a day?
Explain about network model?