Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144513 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / kumaresan chandran
A candidate key is one that can identify each row
of a table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
A key formed by combining at least two or more
columns is called composite key.
| Is This Answer Correct ? | 89 Yes | 27 No |
Post New Answer View All Answers
Explain about post-relational databases?
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?
In which table collections errors are stored.
What is dbms explain in brief?
What is the maximum length of an extended property?
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?
How to use timestamp datatypes
State the acid rules?
What is database design and development?
How long can an error message be in raiseerror function?
In which database can extended stored procedures be added?
Who are end users in dbms?
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?
Explain the rollup operator?
Explain about the relational database?
