Define candidate key, alternate key, composite key?
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 dbms and its application?
How would you design a database for an online site, which would average a million hits a day?
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
How to combine two function together?
How to read and create .LDC data files which are used by linguatic dictionary.
explain detail about ftp in datastage?
State the acid rules?
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.
What is an application role and explain a scenario when you would use one?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain about relational database management systems?
What are the types of database model?