Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145660 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / deependra kumar shukla
Candidate key:- A key 'X' is said to be candidate key if proper subset of 'X' is not a key where X is simple or composite key.
Alternate key:- A candidate key is said to be Alternate key if it is not defined as primary key.An Alternate key may accept null values.
Composite key:- A key is said to be composite key if it contain more than one atribute of the relation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data modeling with example?
How can you fix a poorly performing query?
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?
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?
How can you log an error to the server event log from a stored procedure?
Why does this query return 0?
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?
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?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How is data stored in dbms?
Explain the rollup operator?
What is the maximum length of an extended property?
What are the three types of database design?
What is a database development?
Explain about normal forms?
