Define candidate key, alternate key, composite key?
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
Explain the role of indexing in databases?
Explain the rollup operator?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
How to customize error conditions.
How can you fix a poorly performing query?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to generate OIDS
What is dbms and its application?
Explain about query and reporting.
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 DB Development software?
How long can an error message be in raiseerror function?
Explain about relational database management systems?