Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145547 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
fact table and dimension table containg one to many relationship or many to one relastionship
Explain about relational database management systems?
Explain the role of indexing in databases?
How can you log an error to the server event log from a stored procedure?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
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 is data stored in dbms?
Explain what a database is?
Explain about network model?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are data modelling techniques?
Can an extended stored procedure be called from inside a user-defined function?
Explain about the storage and physical database design?
How to use online Backups?
How to customize error conditions.
