Define candidate key, alternate key, composite key?
Answer Posted / zulfiqar ali
ANSWER 22.. 1 A candidate key is the combination of one or
more attributes which is used to identify records uniquely a
candidate can be selected as a primary key.
2 A key which is not selected is called Alternate key.
3 combination of attributes is called composite key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain about network model?
State the acid rules?
What are the key features of dbms?
Explain about post-relational databases?
What is database design and development?
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.
explain detail about ftp in datastage?
What are the main phases of database development?
Can an extended stored procedure be called from inside a user-defined function?
fact table and dimension table containg one to many relationship or many to one relastionship
How to replace not in with not exist?
How to generate OIDS
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?
What are the constraints on severity level in raiseerror?