Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145536 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
Explain the process of the user request and data generating?
What are the three basic rules which are to be followed for the relational model of the database?
How is data stored in dbms?
What is normalization? Explain different levels of normalization?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Why does this query return 0?
Explain about the relational database?
Write short notes on manual refreshes.
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What are the three types of database design?
Explain about query and reporting.
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?
Explain about the database management systems.
Explain about xml databases?
How you can make a parameterized view?
