Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 146559 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / viresh rajput
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:-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:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is normalization? Explain different levels of normalization?
What are the three types of database design?
Explain the role of indexing in databases?
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?
How long can an error message be in raiseerror function?
How to combine two function together?
How can I detect whether a given connection is blocked?
How can you fix a poorly performing query?
fact table and dimension table containg one to many relationship or many to one relastionship
How is data stored in dbms?
What are the 18 schemas?
