Define candidate key, alternate key, composite key?
Answer Posted / raju
candidate key:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a
table, in which one should be a primary key.
alternate key:-In the candidate key the key which is not
primary key is the alternate key.
composite key:- A key formed bythe combination of 2 or more
columns is the composite key.
| Is This Answer Correct ? | 52 Yes | 24 No |
Post New Answer View All Answers
What is dbms and its application?
Which data type cannot be used as a parameter in a udf?
Explain about the storage and physical database design?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What are the types of database model?
Can an extended stored procedure be called from inside a user-defined function?
I have a few records all are same structures data, I want to store data in multiple targets how
How can you fix a poorly performing query?
How would you design a database for an online site, which would average a million hits a day?
Which four data types cannot be used as a return type from a user-defined function?
Explain about the database management systems.
How can you log an error to the server event log from a stored procedure?
How to combine two function together?
How to generate OIDS
State the acid rules?