Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144738 Views
- IAS, IBM, I also Faced
- E-Mail Answers
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
I have a few records all are same structures data, I want to store data in multiple targets how
Explain what a database is?
Who are end users in dbms?
What are the three types of database design?
How to generate OIDS
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
How would you design a database for an online site, which would average a million hits a day?
What are the key features of dbms?
What is an application role and explain a scenario when you would use one?
What is database design and development?
What are the types of database model?
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?
Where is dbms used?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
