Define candidate key, alternate key, composite key?
- 30 Answers
- 141143 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / piyush kathayat
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 ? | 587 Yes | 62 No |
Post New Answer View All Answers
How to customize error conditions.
Explain about relational operator join?
I have a few records all are same structures data, I want to store data in multiple targets how
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
What is database design and development?
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 are the types of database model?
How long can an error message be in raiseerror function?
What are the 18 schemas?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Explain about the storage and physical database design?
Why does this query return 0?
In which database can extended stored procedures be added?
Which four data types cannot be used as a return type from a user-defined function?
What is dbms and its application?
