Define candidate key, alternate key, composite key?
Answer Posted / palanivel
primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.
Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.
Composite key:- A primary key that consistsof two or more
attributes is known as composite key
candidate key:- is a column in a table which has the
ability to become a primary key.
Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
I have a few records all are same structures data, I want to store data in multiple targets how
Explain about xml databases?
Explain the cube operator?
How can you log an error to the server event log from a stored procedure?
Explain what a database is?
What is DB Development software?
What is a database development?
Why does this query return 0?
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?
How can I detect whether a given connection is blocked?
What is normalization? Explain different levels of normalization?
Explain about the relational database?
Explain about the database management systems.
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 dbms and its application?