Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144838 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
A composite Key can be either Primay or Unique Key
More then One Key columns are said to be composite keys
Candidate Key(Primary Key) is a Key which Maintains the Row
Uniue .Can be defined based on the Entity
Alternate Key or Unique Key is similar to PK ,except it
accepts null Values .So that the records can still be
entered submitting null values to this attribute.
| Is This Answer Correct ? | 151 Yes | 207 No |
Post New Answer View All Answers
What are the three types of database design?
How to combine two function together?
Why does this query return 0?
What is DB Development software?
What are the constraints on severity level in raiseerror?
Which data type cannot be used as a parameter in a udf?
How is data stored in dbms?
Who are end users in dbms?
How can you fix a poorly performing query?
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).
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
State the acid rules?
Explain the process of the user request and data generating?
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 key features of dbms?
