Define candidate key, alternate key, composite key?
Answer Posted / deependra kumar shukla
Candidate key:- A key 'X' is said to be candidate key if proper subset of 'X' is not a key where X is simple or composite key.
Alternate key:- A candidate key is said to be Alternate key if it is not defined as primary key.An Alternate key may accept null values.
Composite key:- A key is said to be composite key if it contain more than one atribute of the relation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain about network model?
How is data stored in dbms?
How can you fix a poorly performing query?
Explain about normal forms?
How to customize error conditions.
Explain about a primary key?
Explain what a database is?
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.
Why does this query return 0?
State the acid rules?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What is database design and development?
How to read and create .LDC data files which are used by linguatic dictionary.
What is the database development process?
Explain about the database management systems.