Define candidate key, alternate key, composite key?
- 30 Answers
- 137538 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjay p sonar
Candidate key:-A candidate key is unique. We may say that
candidate key is another name of primary key. We can have
more than one candidate key. From which we have to choose
one as a primary key.
Alternate key:-The Candidate key other than primary key is
Alternate key. We can have more than one Alternate keys.
Composite key:- When we combine more than 1 column by key
then that key is called Composite key
Clustered Key:- When we combine more than 1 column to form
Primary key then it will become Cluster key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is an application role and explain a scenario when you would use one?
How can you log an error to the server event log from a stored procedure?
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 is a database development?
Explain about relational operator join?
State the acid rules?
What are the 18 schemas?
What are the constraints on severity level in raiseerror?
What is DB Development software?
What are data modelling techniques?
Explain about the relational database?
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.
